1.2.2.13.Copy table

  • LIKE

CREATE TABLE StudentsBackup1 LIKE StudentsDetails;
INSERT studentsBackup1 SELECT * FROM studentsdetails;

  • AS

CREATE TABLE studentsBackup2 AS SELECT * FROM studentsDetails;
Previous1.2.2.12.Deleting a Data from a Table Using DELETENext1.2.2.14.Deleting a Table - DROP TABLE

Last updated

Was this helpful?