Showing posts with label mysql workbench. Show all posts
Showing posts with label mysql workbench. Show all posts

Saturday, June 23, 2012

MySQL Workbench: Copy Table Structure and Data

Right mouse click the table you want to copy and choose, "Send to SQL Editor -> Create Statement"
Select all and execute the statement (lightening bolt icon)
In SQL statement, change table name
Then execute the statement:

INSERT INTO `table2` SELECT * FROM `table1`