第一个表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数据库
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数据库
select * from t_city_fore where 1>2
create table t_npc_fore like t_city_fore 吗?
13.1.5. CREATE TABLE语法CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)];