MySQL的Merage引擎试用

最新推荐文章于 2024-03-16 21:06:13 发布

老紫竹

最新推荐文章于 2024-03-16 21:06:13 发布

阅读量1.9k

点赞数

文章标签： mysql table testing insert null merge

drop table if exists t1;
drop table if exists t2;
drop table if exists total;
CREATE TABLE t1 (
   a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
message CHAR(20));

CREATE TABLE t2 (
   a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
   message CHAR(20));

INSERT INTO t1 (message) VALUES ('Testing'),('table'),('t1');
INSERT INTO t2 (message) VALUES ('Testing'),('table'),('t2');

CREATE TABLE total (
   a INT NOT NULL AUTO_INCREMENT,
   message CHAR(20), INDEX(a))
   TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;

select * from total;
INSERT INTO t1 (message) VALUES ('Testing'),('table'),('t1');
INSERT INTO t2 (message) VALUES ('Testing'),('table'),('t2');
select * from total;

运行结果