Ask for advice. How can this problem be solved?

Ask for advice. I found the data I want from the database. For example, QQ number. I want to pick out the number starting with 6. Then let the batch of data be automatically built into the table. I will only create the table manually. please give us some advice, create & nbsp; table & nbsp; new_table & nbsp; select & nbsp; * & nbsp; from & nbsp; old_tabl.
I found the data I want from the database. For example, QQ number. I want to pick out the number starting with 6. Then let the batch of data be automatically built into the table. I will only manually create the table. please give us some advice,
------ Solution --------------------
Create table new_table select * from old_table where Expression
------ Solution --------------------
CREATE [TEMPORARY] TABLE [if not exists] tbl_name
[(Create_definition,...)]
[Table_options] [select_statement]