MySQL学习笔记（一）----基础 增删查改

学习来源

一、准备工作

二、单表查询

三、多表查询

1.join … on …

用于将两个表以相等的条件连接起来

select *
from customer
join address
	on customer.address_id =  address.address_id

上述代码也可写成

select *
from customer c
join address a
	on c.address_id =  a.address_id

2.自连接

在这里就是起个别名用于区分两张表

select *
from employees e
join employees m
	on e.address_id =  m.manager_id

3.多表连接

select *
from customer c
join address a
	on c.address_id = a.address_id
join store s
	on c.store_id = s.store_id

4.复合连接条件

select *
from customer c
join address a
	on c.address_id = a.address_id
	AND c.status = a.status

四、插入、更新、删除数据