Re: Insert with multiple value lists

2004-02-09 Thread Victoria Reznichenko
Duncan Hill <[EMAIL PROTECTED]> wrote: > While reading the manual the other day, I noticed that MySQL supports a syntax > of INSERT INTO table VALUES (x),(y),(z). Very handy, and nice and fast. > However, when this syntax was tested on an AS/400 and an Ingres installation, > it doesn't work.

Insert with multiple value lists

2004-02-07 Thread Duncan Hill
While reading the manual the other day, I noticed that MySQL supports a syntax of INSERT INTO table VALUES (x),(y),(z). Very handy, and nice and fast. However, when this syntax was tested on an AS/400 and an Ingres installation, it doesn't work. The manual doesn't list this format as an exten