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 where I would expect it to be mentioned.
Also the same goes with this statement
INSERT INTO yourtable VALUES (1, 2), (5, 5);
I believe this is also not part of ANSI standard! Am I correct?
Thanks
> 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/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
> /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
> <___/ www.mysql.com
>
>
>
> -----Original Message-----
> From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 13, 2001 1:56 AM
> To: [EMAIL PROTECTED]
> Subject: INSERT INTO ... SET ...
>
>
> Hi all,
>
> A week ago or so, someone on this list had a problem with inserting
> data.
>
> I thought the reason was because they had mixed up the INSERT and UPDATE
> statements. ie. INSERT INTO table_name SET column1=a_value,
> column2=a_value, ...
>
> However, they said this statement works from the MySQL prompt. I have
> just found time to try this syntax today and I was amazed to find that
> it does work in MySQL though it didn't work for Access.
>
> 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 other DBs support this? 4. If it
> is valid, where is it documented? All the SQL books that I've ever come
> across, do not contain such a syntax.
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
