MySQL知识点(2020-4-29)
1.左连接(left join on)
左连接,以左表为主,数据是全的,右表来匹配,如果匹配不到就是null
select
A.*,
B.*
from A
left join A on A.行=B.行;
4.右连接(right join on)
select
A.*,
B.*
from A
right join B on A.行=B.行;
3.内连接(inner join on)
等值连接(内连接)相当于两个表的交集
select
A.*,
B.*
from A
inner join B on A.行=B.行;
8.limit
select * from 表 limit number; #查询后展示的行数
如:
select * from stu limit 1; #查询后仅仅将结果展示1行
9.SQL语句
select
字段
where YYY
group by 字段
having 字段
order by 字段
limit number;