读取第一行select * frommytableorder byIDasc limit 0,1读取最后一行select * from mytable order by ID desclimit 0,1读取前100行select * frommytableorder byIDasc limit 0,100 mytable即是要读取的表名,ID是要排序的对象。
读取第一行select * frommytableorder byIDasc limit 0,1读取最后一行select * from mytable order by ID desclimit 0,1读取前100行select * frommytableorder byIDasc limit 0,100 mytable即是要读取的表名,ID是要排序的对象。