基础sql - zLulus/My_Note GitHub Wiki

数据定义

Create Table,Alter Table,Drop Table, Craete/Drop Index等

CREATE TABLE Student(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(50) NOT NULL);//建表

CREATE VIEW view_name AS
Select * FROM Table_name;//建视图

Create UNIQUE INDEX index_name ON TableName(col_name);//建索引

数据操纵

select,insert,update,delete

INSERT INTO tablename (column1,column2,…) values(exp1,exp2,…);//插入

UPDATE tablename SET name=’zang 3’where condition;//更新数据

DELETE FROM Tablename WHERE condition;//删除

数据控制

grant && revoke
SQL之Grant(分配权限)和Revoke(回收权限)