mysql分表技术

CREATE TABLE tab1(id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,ename VARCHAR(30),birthdate DATE) ENGINE=MYISAM ;
CREATE TABLE tab2(id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,ename VARCHAR(30),birthdate DATE) ENGINE=MYISAM ;
CREATE TABLE tab3(id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,ename VARCHAR(30),birthdate DATE) ENGINE=MYISAM ;
CREATE TABLE taball(id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,ename VARCHAR(30),birthdate DATE) ENGINE=MGR_MyISAM UNION=(tab1,tab2,tab3) INSERT_METHOD=LAST ;

 

注意：确认分表均需使用MyISAM引擎