Copy Structure and Records in MySql, Clone table in mysql

Copy a existing table structure and datas into new table

CREATE TABLE enquirydetail1 LIKE enquirydetail;
INSERT enquirydetail1 SELECT * FROM enquiry;

 

 

 

Advertisements