sql笔记

关系运算

并

差

交

笛卡尔积

选择

投影

除

连接

半连接

外连接

外部并

聚集函数

SQL

DQL    select

DML    insert delete update

TPL

DCL    grant revoke

DDL    create drop alter

CCL

例：

create database databaseName;
use databaseName;


create table tableName
    (field1 datatype,
field2 datatype,
Integrity constraints);

insert into tableName
(col1,col2,...)
values(value1,value2,...);

delete from tableName where ...
drop
alter
update tableName set col1 = value1,... where


select col1,col2,... from table1,table2 where ...


create view viewName as <sql expr>