Hi!
>>>>> "Eric" == Eric Thelin <[EMAIL PROTECTED]> writes: Eric> On Sat, 20 Apr 2002 [EMAIL PROTECTED] wrote: >> 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. <cut> >> 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. The problem is that INSERT_METHOD only works in MySQL 4.0, not in 3.23 If you need this feature, then you should download the MySQL 4.0.1 distribution and try this out. The MySQL 4.0 series has been out a while now and has in practice proven to be be quite stable.. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --------------------------------------------------------------------- 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
