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
> 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
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/
__ ___ ___ __
/ |/ /_ __
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