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
