mysqlHow to duplicate table structure and data
CREATE TABLE new LIKE old;
INSERT INTO new SELECT * FROM old;ctrl + cCREATE TABLE newcreate new table named | LIKE oldour |
INSERT INTO new SELECT * FROM oldwill copy all the data from | |
More of Mysql
- How to find my.cnf config file
- Insert new values only if row doesn't exist already
- Get largest tables list
- Truncate all tables in a specific database
- Make a pager (limit / offset) select query
- What is the MEDIUMTEXT column max size (length) in Mysql
- How to find duplicate varchar/text column values in table
- What is the INT column max value and size
- Replace string with regex
- Get table engine
See more codes...