SQL : move data

July 14, 2021 admin No Comments สู่เส้นทางดิจิตอล

BEGIN TRANSACTION;
INSERT INTO Table2 (<columns>)
SELECT <columns>
FROM Table1
WHERE <condition>;

DELETE FROM Table1
WHERE <condition>;

COMMIT;