求教一条SQL建表结构的语句。

[llj480028]

第一个表t_city_fore结构如下：
cid fbb fgjbb fjybb fqb fgjqb fjyqb fqib fgjqib fjyqib fgnb fxz fcc fsc fqzb fjfz fzgn fmf fhbq fbyqb fjgjw fppl
0 400 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 0 0 0 100 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0
6 20 0 0 86 0 0 210 0 0 20 10 0 0 0 0 0 0 0 0 0 0
7 60 0 0 67 0 0 41 0 0 22 14 0 0 0 0 0 0 0 0 0 0
怎么能用SQL建第二个表t_npc_fore结构相同?
mysql数据库

[WWWWA]

create table t_npc_fore as
select * from t_city_fore where 1>2

[wangxinli_nissan]

Create table t_npc_fore (Select * from t_city_fore where cid=-1);

[yangxiao_jiang]

mysql不支持
create table t_npc_fore like t_city_fore 吗？

[ACMAIN_CHM]

create table t_npc_fore like t_city_fore;

[ACMAIN_CHM]

参见手册中create table的第二种格式。

http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#create-table
13.1.5. CREATE TABLE语法

CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)];