mysql无法创建表1113_無法創建表＃1113 - 表必須至少有1列

CREATE TABLE t1 ( a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, message CHAR(20)) ENGINE=MyISAM;

CREATE TABLE t1(INT NOT NULL AUTO_INCREMENT PRIMARY KEY,消息CHAR(20))ENGINE = MyISAM;

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

CREATE TABLE t2(INT NOT NULL AUTO_INCREMENT PRIMARY KEY,消息CHAR(20))ENGINE = MyISAM;

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

INSERT INTO t1(消息)VALUES('Testing'),('table'),('t1'); mysql> INSERT INTO t2(消息)VALUES('Testing'),('table'),('t2');

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

CREATE TABLE total( - >一個INT NOT NULL AUTO_INCREMENT, - >消息CHAR(20),INDEX(a)) - > ENGINE = MERGE UNION =(t1,t2)INSERT_METHOD = LAST;