Re: Syntax error with merge tables

2002-04-22 Thread Michael Widenius
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

Re: Syntax error with merge tables

2002-04-20 Thread Eric Thelin
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the merge tables themselves work in later 3.23 versions. If this is the case the documentation needs to be updated to show which version supports what. Eric On Sat, 20 Apr 2002, Benjamin Pflugmann wrote: Hi. AFAIK, insert

Re: Syntax error with merge tables

2002-04-20 Thread Benjamin Pflugmann
Hi. On Sat, Apr 20, 2002 at 01:12:14AM -0700, [EMAIL PROTECTED] wrote: Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the merge tables themselves work in later 3.23 versions. As I said, INSERT for MERGE was introduced in 4.0 (including INSERT_METHOD). Of course, MERGE

Re: Syntax error with merge tables

2002-04-19 Thread Eric Thelin
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

Re: Syntax error with merge tables

2002-04-19 Thread Benjamin Pflugmann
Hi. AFAIK, insert for MERGE tables was introduced in version 4.0.0. Let's see... yep, http://www.mysql.com/doc/N/e/News-4.0.0.html says so. Regards, Benjamin. PS: The syntax you used should be fine with a version supporting it On Fri, Apr 19, 2002 at 04:00:02PM -0700, [EMAIL