Mysql查询数据库表中前几条记录
两层嵌套的方法
select * from student where id not in (select t . id from (select * from student limit 7 ) as t );
Mysql查询数据库表中前几条记录的方法记含义:
select * from student limit 5 ; // 取出前五条记录
select * from student limit 0 ,5; //取出前五条记录 select * from student limit 3,10;//取出3后面的10条记录,不包括3select*from student order by rand() limit 2; // 从表中随机取出2 条记录,这里2 可以自己改