Re: INSERT INTO ... SET ...

2001-07-13 Thread Rolf Hopkins
Ok, I must have been blind or something. However the question still remains. Is this an added feature of MySQL and is not part of ANSI standard? I guess it is because I've never come across it before. I have tried searching the manual again on this, especially Ch 5 but found nothing. This is w

RE: INSERT INTO ... SET ...

2001-07-13 Thread Chris Bolt
> 3. Is this a MySQL feature / bug or do other DBs support this? It doesn't work in Postgres. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

RE: INSERT INTO ... SET ...

2001-07-13 Thread Jorge del Conde
Hi, >From the manual: "The col_name=expression syntax is supported in MySQL Version 3.22.10 or later." Section 7.21 INSERT Syntax http://www.mysql.com/doc/I/N/INSERT.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __

Re: INSERT INTO ... SET ...

2001-07-12 Thread John Birrell
On Fri, Jul 13, 2001 at 02:56:05PM +0800, Rolf Hopkins wrote: > In all the years I have worked/studied SQL, not once have I come across the > INSERT INTO ... SET ... syntax. > My questions are: > > 1. Is this a valid statement? > 2. Is it ANSI standard? > 3. Is this a MySQL feature / bug or do ot