How to create another table from existing one in mysql

Following is the mysql syntax for creating new table from an existing one with same structure and data. this type of query is quite useful while you want to create a backup like thing of an existing table. Query is as follows- Following is the mysql syntax for creating –

CREATE TABLE new_table
AS
(SELECT * FROM old_table)

Posted in PHP