MYSQL常用知识

1.sql执行顺序:

FROM => JOIN => ON => WHERE =>GROUP BY => HAVING => SELECT => ORDER BY => LIMIT

2.计算两个日期相差的天数:

select datediff('2020-10-01','2020-09-03') a  from dual;

后续待补充。。