CREATE TABLE常用命令
来源:互联网 发布:中国互联网金融数据 编辑:程序博客网 时间:2024/05/17 09:34
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);
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);
- CREATE TABLE常用命令
- CREATE TABLE常用命令
- create table
- CREATE TABLE
- CREATE TABLE
- create table
- Create Table
- Create table
- create table
- CREATE TABLE
- create table
- create table
- CREATE TABLE
- CREATE TABLE
- CREATE TABLE
- Create Table中的秘密!
- php create html-table
- BAAN不能create table?
- 7.C++ 数组
- JDK6和JDK7中String的substring()方法及其差异
- 软件测试
- Webkit代码阅读心得
- unity3d教程:游戏开发算法(四)
- CREATE TABLE常用命令
- Oracle 11g New 热补丁
- 那些争议最大的编程观点
- 开头-C 标准库
- PDB文件:每个开发人员都必须知道的
- 小波讲座
- cookie总结
- 连接表
- (阶段四1.4)LA 3708 Graveyard(一个圆圈上有n个点,新加入m个点,求每个点的最小移动距离)