How to Copy data in Same Tbale Uisng MySql

Question

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

Mahesh Chand · Answer

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