https://mp.weixin.qq.com/s/ODp_2BqEyOb61HQdY7jdEg
1、LIMIT 语句
2、隐式转换
3、关联更新、删除
4、混合排序
5、EXISTS语句
6、条件下推
7、提前缩小范围
8、中间结果集下推
https://blog.csdn.net/weixin_39605345/article/details/113085998
where having on区别
https://zhuanlan.zhihu.com/p/45338392
left on right on区别
https://www.jianshu.com/p/43c5f133147e
explain select_type
https://www.jianshu.com/p/313cd30ac95a
explain type
安装教程:
https://blog.csdn.net/weixin_41918841/article/details/121397833
mysql:
http://itsoku.com/course/3
100w的数据表比1000w的数据表查询更快吗?
https://mp.weixin.qq.com/s/Atq9sz5UqpBAPMaY2JDSyQ
10.SQL语句优化的30种方法
https://mp.weixin.qq.com/s/fEdjNPZqxXHgnYKQgl_6Lw
11.sql注入
https://mp.weixin.qq.com/s?__biz=MzI1NDY0MTkzNQ==&mid=2247501774&idx=2&sn=66ba2baffd99e8ffe27103bb1e2d247f&chksm=e9c095aedeb71cb8b712be26f8d411a20b17ec4d3b32a348f91a4cfe878cf8f65ee2b399be29&scene=132#wechat_redirect
12.无则插入 有则不插入
https://blog.csdn.net/qq_35939417/article/details/106358433
https://www.cnblogs.com/luoxiao1104/p/17027999.html
13.更新时间为当前时间戳
update user
set update_time = CURRENT_TIMESTAMP
where id = '111';