create 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 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);
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步