On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > I always get a syntax error when using INSERT_METHOD in creating merge > tables. If I leave off the INSERT_METHOD part it works fine. I have > tried this on many versions in the past and now on 3.23.49a. I am > running on Mandrake Linux 8.1 but have seen this same error on other > linux distros. It is my understanding from reading the manual that the > following should work but it doesn't. > > CREATE TABLE mytable0 ( > a INTEGER NOT NULL PRIMARY KEY, > b CHAR(18) NOT NULL > ); > > CREATE TABLE mytable1 ( > a INTEGER NOT NULL PRIMARY KEY, > b CHAR(18) NOT NULL > ); > > CREATE TABLE mytable2 ( > a INTEGER NOT NULL PRIMARY KEY, > b CHAR(18) NOT NULL > ); > > CREATE TABLE mytable ( > a INTEGER NOT NULL PRIMARY KEY, > b CHAR(18) NOT NULL > ) TYPE=MERGE UNION=(mytable0, mytable1, mytable2) INSERT_METHOD=LAST; > > Since the .MRG files are plain text could someone send me what the > INSERT_METHOD part is supposed to look like so I can do it manually if > needed. Thanks. > > Eric > >
--------------------------------------------------------------------- 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