2020-10-23

mysql

mysql3小时快速入门
01基础

select * 
from customers
-- 条件判断
where first_name regexp 'ey'
and points > 100
-- 排序
order by first_name desc
-- 索引
limit 3

02连接查询

-- 左右连接
select *
from customers c
join orders o
on c.customer_id = o.customer_id

-- 上下连接
from customers
where points > 3000
union
select first_name,
points
from customers
where points <1000

03数据操作

-- 插入
insert into shippers(name)
values ('name1'),
	('name2');
-- 修改
update shippers
set name = 'marry'
where name = 'name1';
-- 删除
delete from shippers
where name = 'name2'