读取MYSQL数据库中某个表的第一行和最后一行数据_MySQL

select * frommytable order byIDasc limit 0,1

读取最后一行

select * from mytable order by ID desclimit 0,1

读取前100行

select * from mytable order byIDasc limit 0,100