Table Clone in MySQL Copy a existing table structure and datas into new table CREATE TABLE enquirydetail1 LIKE enquirydetail; INSERT enquirydetail1 SELECT * FROM enquiry;
Read MoreTag: optimization
How to import table from other database in MySQL
Import a record from other Database How to import a record from another database table in mysql ? Same Table Structure in Source and Destination Table INSERT INTO <TABLENAME> SELECT * FROM <DESTINATION DATABASENAME>.<TABLENAME> Transfer from Limited Fields INSERT INTO <TABLENAME> (col1, col2) SELECT (col1, col2) FROM <DESTINATION DATABASENAME>.<TABLENAME> Transfer from Limited Fields with Condition INSERT INTO <TABLENAME> (col1, col2) SELECT (col1, col2) FROM <DESTINATION DATABASENAME>.<TABLENAME> where condition.field = condition.value
Read More