create table table_new_name as (select id,name,age from users where age='18') 注:table_new_name 新创建的表名;