CREATETABLE常用命令
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 STUDENTS SELECT * FROM STUDENTS; DELETE STUDENTS FROM STUDENTS WHERE stuID = 1; DROP TABLE STUDENTS; ALTER TABLE STUDENTS ADD CONSTRAINT PRIMARY KEY (stuID); ALTER TABLE STUDENTS ADD PRIMARY KEY (stuID);
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。