比如建这个表怎么建,帮忙建一下
Table Name client
No PK, FK Column Name Type Length Null
01 PK c_id CHARACTER 4 N
02 company_nm CHARACTER 50
03 dept CHARACTER 50
04 address CHARACTER 50
05 siteLink CHARACTER 50
06 att CHARACTER 200
Table Name client
No PK, FK Column Name Type Length Null
01 PK c_id CHARACTER 4 N
02 company_nm CHARACTER 50
03 dept CHARACTER 50
04 address CHARACTER 50
05 siteLink CHARACTER 50
06 att CHARACTER 200
-> `c_id` varchar(4) primary key,
-> `company_nm` varchar(50),
-> `dept` varchar(50),
-> `address` varchar(50),
-> `siteLink` varchar(50),
-> `att` varchar(50)
-> );
Query OK, 0 rows affected (0.14 sec)
-> `c_id` varchar(4) identity(1,1) primary key,
-> `company_nm` varchar(50),
-> `dept` varchar(50),
-> `address` varchar(50),
-> `siteLink` varchar(50),
-> `att` varchar(50)
-> );
Query OK, 0 rows affected (0.14 sec)
自动增长列!
`c_id` varchar(4) primary key,
`company_nm` varchar(50),
`dept` varchar(50),
`address` varchar(50),
`siteLink` varchar(50),
`att` varchar(50)
);MYSQL中有identity(1,1)?
c_id varchar(4) ,
company_nm varchar(50),
dept varchar(50),
address varchar(50),
siteLink varchar(50),
att varchar(200),
primary key(c_id)
);