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 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.
It's documented in MySQL: http://www.mysql.com/doc/I/N/INSERT.html.
That page says it has been supported since 3.22.10.
--
John Birrell - [EMAIL PROTECTED]; [EMAIL PROTECTED]
---------------------------------------------------------------------
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