Select * from user limit 1,2 in the example, still a bit unclear? -PHP Chinese website Q&A-Select * from user limit 1,2 in the example, still a little unclear? -PHP Chinese website Q&A
Please watch and learn.
limit是mysql的语法Select * from table limit m,n其中m是指记录开始的index,从0开始,表示第一条记录n是指从第m+1条开始,取n条。Select * from user limit 1,2即取出第2条至第3条,共2条记录
查询user表中的数据,从第一条开始取,取俩条数据。
Select * from user limit 1,2 in the example, still a bit unclear? -PHP Chinese website Q&A-Select * from user limit 1,2 in the example, still a little unclear? -PHP Chinese website Q&A
Please watch and learn.
limit是mysql的语法
Select * from table limit m,n
其中m是指记录开始的index,从0开始,表示第一条记录
n是指从第m+1条开始,取n条。
Select * from user limit 1,2
即取出第2条至第3条,共2条记录
查询user表中的数据,从第一条开始取,取俩条数据。