Is it feasible to delete and then insert when updating database tables?

is it feasible to delete and then insert when updating database tables?
the contents of the table are many-to-many relationships

Mar.16,2021

as long as you can make sure that this has no side effects or does not care the side effects .

side effects include, but are not limited to: the associated record must have an impact when it is deleted, and what if it is queried during this period?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1be8f1d-31933.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1be8f1d-31933.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?