For backup and other requirements we often have to copy the data of a table or copy the total table structure with data. We can selectively copy the data of a MySQL table to a new table or copy the total data to a new table. We will learn here different techniques here on how to do this

CREATE TABLE student2 SELECT * FROM student WHERE class=’Four’