Jennifer,
It is the third alternative syntax.
or INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
SET col_name=(expression | DEFAULT), ...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
Louise
----- Original Message -----
From: Jennifer Goodie <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 06, 2003 6:17 AM
Subject: RE: Using SET in the INSERT statement
: Are you referring to the data type SET or the Command SET? The manual
page
: you point to is talking about the data type, but usually when seen in
an
: insert it is the Command. I can't recall seeing the datatype referred
to in
: an INSERT, but maybe my brain isn't fully on yet today.
: http://www.mysql.com/doc/en/INSERT.html
:
:
:
: -----Original Message-----
: From: boclair [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 04, 2003 8:19 PM
: To: [EMAIL PROTECTED]
: Subject: Using SET in the INSERT statement
:
:
: I notice some of my colleagues using SET in INSERT statements.
:
: DuBois makes a short reference on p565, DoorStop1.
:
: The Manual has some mention in http://www.mysql.com/doc/en/SET.html
:
: I sort of get it but I am looking for a fuller explanation.
:
: Louise
:
:
:
:
:
: ---------------------------------------------------------------------
: 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
:
---------------------------------------------------------------------
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
