Answers for "innodb fast move rows between tables"

0

innodb fast move rows between tables

INSERT INTO table2
SELECT *
FROM table1
WHERE <your_where_clause>

DELETE FROM table1 
WHERE table1.id in
(SELECT table2.id 
FROM table2)
Posted by: Guest on October-10-2021

Code answers related to "innodb fast move rows between tables"

Browse Popular Code Answers by Language