27

8种经常被忽视的SQL错误用法，你有没有踩过坑？

 4 years ago
source link: https://juejin.im/post/5dd15451e51d453b3d3d4329
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
1、LIMIT 语句分页查询是最常用的场景之一，但也通常也是最容易出问题的地方。比如对于下面简单的语句，一般 DBA 想到的办法是在 type, name, create_time 字段上加组合索引。这样条件排序都能有效的利用到索引，性能迅速提升。SELECT

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK