php - Move from one table to another -
i need move data table archive table. now way: $sql = 'insert history_products select * products category_id='.$id; and delete data products table. $sql_delete = 'delete products category_id = '.$id; each product have unique id. want make in secure way, if row isn't inserted in history_products row deleted products table. don't want delete if insert fails. i expected have field called id (produktid), products must have same id in both tables then, following should work. delete products products.id in (select history_products.id history_products)