##查询第一行:
select * from tablename limit 0,1;
##查询第二行:
select * from tablename limit 1,1;
##查询第三行:
select * from tablename limit 2,2;
更新:
update tablename1 set cloumnName=xxxx where id in (select t.id from (select id from tablename1 limit 2,2 ) as t )
注意:若用:
update tablename1 set cloumnName=xxxx where id in (select id from tablename1 limit 2,2 )
会报错。不支持:limit。
很少用,但是要知道。