Re: Using SET in the INSERT statement

2003-02-10 Thread Paul DuBois
At 11:37 +1000 2/7/03, boclair wrote: - Original Message - From: Paul DuBois <[EMAIL PROTECTED]> To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 8:47 AM Subject: Re: Using SET in the INSERT statement : At 14:19 +1000 2/5/03, b

Re: Using SET in the INSERT statement

2003-02-08 Thread boclair
- 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 IN

Re: Using SET in the INSERT statement

2003-02-08 Thread boclair
AIL 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

Re: Using SET in the INSERT statement

2003-02-08 Thread boclair
- Original Message - From: Paul DuBois <[EMAIL PROTECTED]> To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 8:47 AM Subject: Re: Using SET in the INSERT statement : At 14:19 +1000 2/5/03, boclair wrote: : >I notice some of my co

Re: Using SET in the INSERT statement

2003-02-08 Thread Paul DuBois
At 14:19 +1000 2/5/03, boclair wrote: I notice some of my colleagues using SET in INSERT statements. DuBois makes a short reference on p565, DoorStop1. The reference is short because there isn't much to say about it. :-) The SET clause consists of col_name=value assignments, separated by comma

RE: Using SET in the INSERT statement

2003-02-06 Thread Jennifer Goodie
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.

Re: Using SET in the INSERT statement

2003-02-06 Thread Keith C. Ivey
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 S