MySQL select语句 汇总
# 选择
SELECT cpu FROM laptop
# 去重
SELECT DISTINCT cpu FROM laptop
# 最多取几条
SELECT id FROM laptop
LIMIT 5
# 从第22行开始取五条
SELECT id FROM laptop
LIMIT 21, 5
# 排序并且降序,升序去掉desc
SELECT `memory` FROM laptop
ORDER BY `memory` DESC
# 下面都是where的操作符
SELECT * FROM l
原创
2020-06-12 15:00:14 ·
220 阅读 ·
0 评论