Mysql query for creating table example sql code for create new table with select command

We can create table with select command from another table with example sql command below

Example sql command for mysql query for creating table

CREATE TABLE new_std_table
  SELECT * from std_table

you can select with specify field name or using where condition , group by , order by for example below

CREATE TABLE new_std_table
  SELECT std_id,std_name from std_table where std_name like '%anna%' order by std_id

 Note: this command will support  MySql DBMS in other DBMS may be some difference