how to insert same table data using mysql query

Solutions on MaxInterview for how to insert same table data using mysql query by the best coders in the world

Search
showing results for - "how to insert same table data using mysql query"
Veronica
13 Aug 2018
1Use INSERT ... SELECT:
2
3insert into your_table (c1, c2, ...)
4select c1, c2, ...
5from your_table
6where id = 1
similar questions
mysql select update same tablemysql insert on dup c3 a8licatemysql update sum same tablemysql update two tables at oncehow to duplicate table in mysqlhow to insert multiple rows in mysql using stored procedureduplicate row mysqlmysql on duplicate key updateinsert data into multiple tables mysqlhow to combine 2 tables in mysqlmysql find duplicates in same tablehow to create a table based on another table in mysqlhow to query all tables mysql at the same timehow to add more columns to a table in mysqlconcat column value of same user in mysqlmysql insert multiple rows based on selectinsert into table from another table mysqlhow to join more then 2 column in mysqlcopy data from one table to another mysqlduplicate record mysqlmysql insert into multiple tablesmysql best way to insert many rows
queries leading to this page
mysql select and insert same tablemysql select and insert into same tablehow to insert data into two table at a same time in mysqlmysql insert same data in all rowshow to insert one table data to same type another table in mysqlhow to insert same data in two tables in mysqlinsert into select mysql same tablehow to create same table in mysql present in another databasemysql insert same data in each columnhow to insert into two tables at the same time mysqlinsert row in table from same table mysqlmysql insert into select from same tableinsert a same column 10000 times in mysqlhow to insert data into 2 different tables but same data in mysqlhow to insert same table data using mysql querymysql select insert into same tablehow to insert same table data using mysql query