Answers for "how can we write query using while loop to copy data from one table and insert to another table"

insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Posted by: Guest on June-30-2020

Code answers related to "how can we write query using while loop to copy data from one table and insert to another table"