一、SQL基础
1.DDL(Data Definition Language)
show databases;
select database();
create database database_name;
drop database database_name;
use database_name;
show tables;
desc table_name;
create table(
id int primary key auto_increment,
name varchar(10)
);
show create table table_name;
alter table table_name add nickname varchar(10) ;
alter table table_name modify nickname varchar(7);
alter table table_name change 旧字段 新字段 数据类型;
alter table table_name drop nickname;
alter table table_name rename to new_name;
drop table table_name;
truncate table table_name;
2.DQL(Data Query Language)
select *|字段名1 as|省略 别名,字段名2 as|省略 别名
from table_name as|省略 别名
where
group by
having
order by
limit
select distinct 字段名 from table_name;
select 聚合函数(字段名) from table_name;
select * from table_name where 条件 group by 字段名 having 筛选;\
select * from table_name order by 字段名 asc|desc;
select *