CREATE TABLE常用命令，table常用命令

CREATE TABLE常用命令，table常用命令

CREATE TABLE students(stuID INTEGER     NOT NULL ,stuname char(30)     not null,sex     int     NOT NULL);CREATE TABLE students(stuID INTEGER     NOT NULL ,stuname char(30)     not null,sex     int     NOT NULL,PRIMARY KEY (stuID));CREATE TABLE students(stuID INTEGER     NOT NULL PRIMARY KEY,stuname char(30)     not null,sex     int     NOT NULL);CREATE TABLE score(scoreID INTEGER NOT NULL PRIMARY KEY,stuID     INTEGER NOT NULL,KEMUID     INTEGER NOT NULL,score     FLOAT,FOREIGN KEY SCORE_ID_FK (stuID) REFERENCES students (stuid),CONSTRAINT CHK_SCORE_ZIP CHECK (SCORE > 0));show tables;insert into students values(1,'張三',1);SELECT * FROM STUDENTS;INSERT INTO STUDENTSSELECT * FROM STUDENTS;DELETE STUDENTS FROM STUDENTSWHERE stuID = 1;DROP TABLE STUDENTS;ALTER TABLE STUDENTS ADD CONSTRAINT PRIMARY KEY (stuID);ALTER TABLE STUDENTS ADD PRIMARY KEY (stuID);