PHP+MYSQL分页（1）sql篇

原创

陈业贵的博客 2021-11-16 17:07:33 博主文章分类：分页原理（PHP+MYSQL） ©著作权

文章标签 数据 文章分类 代码人生

©著作权归作者所有：来自51CTO博客作者陈业贵的博客的原创作品，请联系作者获取转载授权，否则将追究法律责任

create table page1(

ID INT(10) not null auto_increment key,

NAME varchar(50) not null

);

insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);insert into page1(NAME) values(“陈业贵”);

第一为表，第二为插入的数据。