要选择前10条记录,请在MySQL中使用LIMIT。让我们首先创建一个表-mysql> create table DemoTable
-> (
-> PageNumber text
-> );
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values('Page-1');
mysql> insert into DemoTable values('Page-2');
mysql> insert into DemoTable values('Page-3');
mysql> insert into DemoTable values('Page-4');
mysql> insert into DemoTable values('Page-5');
mysql> insert into DemoTable values('Page-6');
mysql> insert into DemoTable values('Page-7');
mysql> insert into DemoTable values('Page-8');
mysql> insert into DemoTable values('Page-9');
mysql> insert into DemoTable values('Page-10');
mysql> insert into DemoTable values('Page-11');
mysql> insert into DemoTable values('Page-12');