Welcome To Ask or Share your Answers For Others

sql查询问题

asked Feb 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

用select* from table limit 5查询表中5条记录，但实际上表中只有2条数据，这样能查询到吗？

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

152 views

Welcome To Ask or Share your Answers For Others

1 Answer

answered Feb 6, 2021 by 深蓝 (71.8m points)

limit 5只是限制最大返回记录数，并没有要求必须返回5条记录，所以，这样写，没毛病！

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

...