----- Original Message ----- From: Keith C. Ivey <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 06, 2003 6:47 AM Subject: Re: Using SET in the INSERT statement
: On 5 Feb 2003, at 14:19, boclair wrote: : : > 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 : : You seem to be confusing two unrelated meanings of SET. The SET in : INSERT statements is mentioned here: : : http://www.mysql.com/doc/en/INSERT.html : : It's just an alternative syntax so that an INSERT query can look like : an UPDATE query. : : The SET from the manual page you mention is a column type and would : be used in creating a table. Thanks, I had not seen the alternate syntax used before, and I was confusing the different usages of SET. 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