MERGE tables and INSERT_METHOD

2001-11-23 Thread Michael Widenius


Hi!

 Chris == Chris Cooper [EMAIL PROTECTED] writes:

Chris Has anyone else tried to set the INSERT_METHOD for MERGE tables? It
Chris keeps throwing a syntax error for me. 

Chris Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html),
Chris here's what I get:

cut

Chris I checked the release notes/changelog, but there's no mention of the
Chris INSERT_METHOD being broken or fixed.

Chris I'm running MySQL version 3.23.42-log on RH 7.1. 

The INSERT_METHOD is only available in MySQL 4.0.0;  I have now
updated the documentation about this.

Regards,
Monty

-
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




MERGE tables and INSERT_METHOD

2001-11-22 Thread Chris Cooper

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