Has anyone else tried to set the INSERT_METHOD for MERGE tables? It
keeps throwing a syntax error for me.
Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html),
here's what I get:
output
mysql CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message
CHAR(20));
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO t1 (message) VALUES (Testing),(table),(t1);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql INSERT INTO t2 (message) VALUES (Testing),(table),(t2);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a))
TYPE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;
ERROR 1064: You have an error in your SQL syntax near
'INSERT_METHOD=LAST' at line 1
end_output
I checked the release notes/changelog, but there's no mention of the
INSERT_METHOD being broken or fixed.
I'm running MySQL version 3.23.42-log on RH 7.1.
--
coop
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php