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`
Ah yeah, I was wondering if there was a quick way of doing that...! Thanx
ReplyDeletecreate table new_table_name(like old_table_name);
ReplyDeleteanther easy to copy tables
Thanks! That's exactly what I needed!
Deleteto copy the data from table
ReplyDeleteinsert into new_table_name(select * from old_table_name);
This comment has been removed by the author.
ReplyDeleteThis was very helpful! Thank you
ReplyDeleteYou know what I love about your content ? it is SUCCINCT .
ReplyDeleteGreat Help, Cheers
ReplyDeletegreat thanks!
ReplyDeleteThanks for this.
ReplyDeleteLovely.you saved souls
ReplyDelete