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]
[code lang=”sql”] — orginalTableName can be same as newTableName CREATE TABLE newTableName LIKE orignalDBName.orignalTableName; INSERT newTableName SELECT * FROM orignalDBName.orignalTableName; [/code]
