Table Clone in MySQL Copy a existing table structure and datas into new table CREATE TABLE enquirydetail1 LIKE enquirydetail; INSERT enquirydetail1 SELECT * FROM enquiry;

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 […]