MySQL建表語(yǔ)法

1、1、最簡(jiǎn)單的:CREATE TABLE t1( id int not n ull, n ame char(20)；2、帶主鍵的:a:CREATE TABLE t1(key,id int not n ull primaryn ame char(20);b :復(fù)合主鍵CREATE TABLE t1(id int not n ull,n ame char(20),primary key (id,name);3、帶默認(rèn)值的:CREATE TABLE t1(id int not null default 0 primary key, n ame char(20)default '1');

2、轉(zhuǎn)貼的：CREATE TABLE PLAYERS(PLAYERNO INTEGER NOT NULL PRIMARY KEY,NAME CHAR(15) NOT NULL,INITIALS CHAR(3) NOT NULL,BIRTH_DATE DATE,SEX CHAR(1) NOT NULLCHECK(SEX IN ('M','F'),JOINED SMALLINT NOT NULLCHECK(JOINED > 1969),STREET CHAR(30) NOT NULL,HOUSENO CHAR(4),POSTCODE CHAR(6) CHECK(P

3、OSTCODE LIKE ''),TOWN CHAR(10) NOT NULL,PHONENO CHAR(13),LEAGUENO CHAR(4)CREATE TABLE TEAMS(TEAMNO INTEGER NOT NULL PRIMARY KEY,PLAYERNO INTEGER NOT NULL,DIVISION CHAR(6) NOT NULLCHECK(DIVISION IN ('first','seco nd'),FOREIGN KEY (PLAYERNO) REFERENCES PLAYERS (PLAYERNO)JCREATE

4、 TABLE MATCHES(MATCHNO INTEGER NOT NULL PRIMARY KEY,TEAMNO INTEGER NOT NULL,PLAYERNO INTEGER NOT NULL,WONSMALLINT NOT NULLCHECK(WON BETWEEN 0 AND 3),LOSTSMALLINT NOT NULLCHECK(LOST BETWEEN 0 AND 3),FOREIGN KEY (TEAMNO) REFERENCES TEAMS (TEAMNO),FOREIGN KEY (PLAYERNO) REFERENCES PLAYERS (PLAYERNO)JCR

5、EATE TABLE PENALTIES(PAYMENTNO INTEGER NOT NULL PRIMARY KEY,PLAYERNO INTEGER NOT NULL,PAYMENT_DATE DATE NOT NULLCHECK(PAYMENT_DATE >= DATE('1969-12-31'),AMOUNT DECIMAL(7,2) NOT NULLCHECK (AMOUNT > 0),FOREIGN KEY (PLAYERNO) REFERENCES PLAYERS (PLAYERNO)JCREATE TABLE COMMITTEE_MEMBERS(PLAYERNO INTEGER NOT NULL,BEGIN_DATE DATE NOT NULL,END_DATE DATE,POSITION CHAR(20),PRIMARY KEY (PLAYERNO, BEGIN_DATE),FOREIGN KEY (PLAYERNO) REFERENCES PLAYERS (PLAY