回复讨论(解决方案) create table new_table select * from old_table where expression
create table new_table select * from old_table where expression
是复制表的意思吗。我在书上的mysql里没看到这句话呀
create [temporary] table [if not exists] tbl_name
[(create_definition,...)]
[table_options] [ select_statement]
一句大大把一堆人都叫老了，