网站开发基本构成,防城港建设局网站,常州网站建设公司报价,长沙网站技术专家参考: https://blog.csdn.net/qq_44732146/article/details/127616258
user.sql 完整的执行一遍#xff0c;可以做到分表和分页
数据是实时的#xff0c;往一张子表里插入之后#xff0c;all表就能立刻查询到
在这里实现分页查询的是MyIsam引擎#xff0c;这个引擎不支持…参考: https://blog.csdn.net/qq_44732146/article/details/127616258
user.sql 完整的执行一遍可以做到分表和分页
数据是实时的往一张子表里插入之后all表就能立刻查询到
在这里实现分页查询的是MyIsam引擎这个引擎不支持事务那么如果要支持事务该怎么办呢 DROP table IF EXISTS dd_user;
create table dd_user(id bigint primary key auto_increment ,name varchar(20),age tinyint not null default 0
) ENGINEMyISAM DEFAULT CHARSETutf8 AUTO_INCREMENT1;DELIMITER $$
CREATE PROCEDURE insert_data_dd_user(count_ INT)
BEGIN
DECLARE i INT;
SET i 1;
WHILE(icount_) DO
INSERT into dd_user(id,name,age) VALUES (i,concat(张三,i),20);
SET i i1;
END WHILE;
COMMIT;
END;$$
DELIMITER ;
call insert_data_dd_user(20000);DROP table IF EXISTS tb_member1;
create table tb_member1(id bigint primary key auto_increment ,name varchar(20),age tinyint not null default 0
)ENGINEMyISAM DEFAULT CHARSETutf8 AUTO_INCREMENT1;
DROP table IF EXISTS tb_member2;
create table tb_member2(id bigint primary key auto_increment ,name varchar(20),age tinyint not null default 0
)ENGINEMyISAM DEFAULT CHARSETutf8 AUTO_INCREMENT1;
insert into tb_member1(id,name,age) select id,name,age from dd_user where id%20;
insert into tb_member2(id,name,age) select id,name,age from dd_user where id%21;DROP table IF EXISTS tb_member_all;
create table tb_member_all(
id bigint primary key auto_increment ,
name varchar(20),
age tinyint not null default 0
)ENGINEMERGE UNION(tb_member1,tb_member2) INSERT_METHODLAST CHARSETutf8 AUTO_INCREMENT1 ;select * from dd_user order by id asc limit 3,5;
select * from tb_member_all order by id asc limit 3,5;
