CREATE TABLE常用命令

最新推荐文章于 2024-08-05 15:53:50 发布

ucan23

最新推荐文章于 2024-08-05 15:53:50 发布

阅读量6.9k

点赞数 1

分类专栏： MySQL 文章标签： select SQL MySQL Database 数据库

本文链接：https://blog.csdn.net/ucan23/article/details/45626075

版权

MySQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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);