checkedresponsive[@]gmail.com

Menu

Tag: optimization

How to clone table in MySQL ?

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

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