MySQL Forums
Forum List  »  Docs

Merge Table Example Error
Posted by: Grum De Henseler
Date: January 20, 2017 03:49PM

In https://dev.mysql.com/doc/refman/5.6/en/merge-storage-engine.html

the example code

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

will result in 1168. I believe you want the following

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


Grum

Options: ReplyQuote


Subject
Views
Written By
Posted
Merge Table Example Error
307
January 20, 2017 03:49PM
178
January 20, 2017 04:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.