没有合适的资源?快使用搜索试试~ 我知道了~
数据库期末复习SQL专项
资源推荐
资源详情
资源评论
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![thumb](https://img-home.csdnimg.cn/images/20210720083646.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![pptx](https://img-home.csdnimg.cn/images/20210720083543.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![exe](https://img-home.csdnimg.cn/images/20210720083343.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![](https://csdnimg.cn/release/download_crawler_static/89443691/bg1.jpg)
CREATE/DROP/ALTER
CREATE SCHEMA
CREATE SCHEMA AUTHORIZATION ;
eg. WANG S-T
CREATE SCHEMA "S-T" AUTHORIZATION WANG;
eg. WANG
CREATE SCHEMA AUTHORIZATION WANG; //
DROP SCHEMA
DROP SCHEMA CASCADE; //
DROP SCHEMA RESTRICT; //
CREATE TABLE
CREATE TABLE
( 1 , //
n ,
1,
n
);
1
CHAR(n) n
VARCHAR(n) n
NUMBER(n) n
INT 4B
SMALLINT 2B
BIGINT 8B
FLOAT(n) n
DATE YYYY-MM-DD
TIME HH:MM:SS
2
PRIMARY KEY //
NOT NULL //
UNIQUE //
CHECK() // CHECK(>20)
3
PRIMARY KEY( 1, n) //
FOREIGN KEY( 1) REFERENCES ( 1) //
eg.
CREATE TABLE TAB1
( Sno VARCHAR(10),
Cno NUMBER(10),
Grade INT NOT NULL,
PRIMARY KEY(Sno, Cno),
FOREIGN KEY(Sno) REFERENCES TAB2(Sno)
);
![](https://csdnimg.cn/release/download_crawler_static/89443691/bg2.jpg)
1
CREATE TABLE .
(,
);
2
CREATE SCHEMA AUTHORIZATION
CREATE TABLE
(,
);
3
ALTER TABLE
1
ALTER TABLE ADD ;
eg. SC
ALTER TABLE SC ADD COLUMN Time DATE;
2
ALTER TABLE ADD ;
eg. SC Cname
ALTER TABLE SC ADD UNIQUE(Cname);
3
ALTER TABLE ADD ;
eg. SC Cno Student
ALTER TABLE SC ADD FOREIGN KEY(Cno) REFERENCES Student(Cno);
4
ALTER TABLE DROP CASCADE; //
ALTER TABLE DROP RESTRICT; //
5
ALTER TABLE DROP CONSTRAINT CASCADE; //
ALTER TABLE DROP CONSTRAINT RESTRICT; //
6
ALTER TABLE ALTER COLUMN ;
eg. SC Sage()
ALTER TABLE SC ALTER COLUMN Sage INT;
DROP TABLE
1DROP TABLE CASCADE; //
2DROP TALBE RESTRICT; // CHECK
FOREIGN KEY
![](https://csdnimg.cn/release/download_crawler_static/89443691/bg3.jpg)
CREATE UNIQUE/CLUSTER INDEX
1
CREATE UNIQUE INDEX ON ( 1 , n );
eg. SC
CREATE UNIQUE INDEX SCno ON SC(Sno ASC, Cno DESC);
2
CREATE CLUSTER INDEX ON ( 1 , n );
ALTER INDEX
ALTER INDEX RENAME TO ;
eg. SC SCno SCSno
ALTER INDEX SCno RENAME TO SCSno;
DROP INDEX
DROP INDEX ;
eg. SC SCSno ;
DROP INDEX SCSno;
SELECT
SELECT DISTINCT/ALL //
FROM / //
WHERE //
GROUP BY HAVING //
ORDER BY ; //
SELECT
1SELECT 1, n
eg. TAB X Y
SELECT X, Y
FROM TAB;
2SELECT *
eg. TAB
SELECT *
FROM TAB;
3SELECT //
eg. TAB age
SELECT 2022-age
FROM TAB;
4SELECT
eg. TAB X Y x1 y1
SELECT X x1, Y y1
FROM TAB;
5SELECT DISTINCT
eg. TAB X
SELECT DISTINCT X, // DISTINCT ALL
FROM TAB;
剩余12页未读,继续阅读
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
![avatar-vip](https://csdnimg.cn/release/downloadcmsfe/public/img/user-vip.1c89f3c5.png)
weixin_74928273
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)