本文主要是一些SQL的常用语法,分类列举,方便记忆,以mysql为例,其他数据库类似。
目录
1,ddl,数据库定义语言
-- ddl
-- 创建
create database database_name;
create table if not exists table_name;
create view view_name as (select * from table_name);
create index index_name on table_name(column_name);
-- 修改
alter table table_name add column column_name(int);
alter table table_name drop column column_name;
alter table table_name rename to new_name;
-- 删除
drop database database_name;
drop table table_name;
drop index index_name;
drop view vie_name;
-- view,视图,
-- Index,索引
2,dml,数据库操作语言
-- dml
insert into table_name(column1,column2) values(value1,value2);
update table_name set column1=value1 where;
delete from table_name where ;
3,dcl,数据库控制语言
-- dcl
grant select,insert on table_name to user_name1;
revoke select,insert on table_name from user_name1;
4,tcl,事务控制语言
-- tcl
start transaction;
COMMIT;
rollback;
5,dql,数据库查询语言
-- dql
select *
from table_name
where name like '李%'
left join table_name1 on table_name.id = table_name1
group by 字段
order by 字段
having 条件
-- like模糊查询
-- left join 左外连接
-- Group by 分组
-- order by 排序
-- having 分组之后筛选条件