Tag Archives - backup

Copy an existing MySQL table to a new table

[code lang=”sql”] — orginalTableName can be same as newTableName CREATE TABLE newTableName LIKE orignalDBName.orignalTableName; INSERT newTableName SELECT * FROM orignalDBName.orignalTableName; [/code]