SERT 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 did
> 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
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 co
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 MySQ
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 stateme
