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 (
> aINTEGER NOT NULL PRIMARY KEY,
> bCHAR(18) NOT NULL
> );
>
> CREATE TABLE mytable1 (
> aINTEGER NOT NULL PRIMARY KEY,
> bCHAR(18) NOT NULL
> );
>
> CREATE TABLE mytable2 (
> aINTEGER NOT NULL PRIMARY KEY,
> bCHAR(18) NOT NULL
> );
>
> CREATE TABLE mytable (
> aINTEGER NOT NULL PRIMARY KEY,
> bCHAR(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
