Loading

How to Copy data in Same Tbale Uisng MySql

Naeem Khan

16y3kSQL

hello friends,
i want to know how can i copy data in same table using MySql. i have 100 Recodes in table and i want to Make Duplicate all Recodes in Same table... so if you have any idea how can i copy all recodes in Same tble then let me know.....

Thanks In Advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand16y ago
Do you want to copy using SQL or code? In code, you can use DataTable class to copy data from one table to other.

If you want to use SQL query, look into INSERT...INTO...FROM SQL statement if copying data from a different database.

You can use SELECT INTO statement if you are copying data within same database.

SELECT Column1, Column2, Column3,
INTO Table2
FROM Table1
0