Re: MySQL gurus - easy one.

2002-01-28 Thread Sherwin Ang
Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: "Odhiambo Washington" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 1:08 PM Subject: MySQL gurus - ea

Re: MySQL gurus - easy one.

2002-01-28 Thread Paul DuBois
At 22:23 -0700 1/28/02, Colin Faber wrote: >Correct, > >If you MUST use date as the column name escape it with forward ticks, >`date` Actually, according to the error message, neither one of you is correct. :-) The message was: ERROR 1064 at line 3: You have an error in your SQL syntax near 'fr

Re: MySQL gurus - easy one.

2002-01-28 Thread Colin Faber
Correct, If you MUST use date as the column name escape it with forward ticks, `date` "Mike(mickalo)Blezien" wrote: > > On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington <[EMAIL PROTECTED]> > wrote: > > >>Please forgive my bad step of joining the list and begining with questions. > >>I'm

Re: MySQL gurus - easy one.

2002-01-28 Thread Mike(mickalo)Blezien
On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington <[EMAIL PROTECTED]> wrote: >>Please forgive my bad step of joining the list and begining with questions. >>I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn >>(self-teaching). >> >> >>I am trying to create a table and

MySQL gurus - easy one.

2002-01-28 Thread Odhiambo Washington
Hello list, Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching). I am trying to create a table and made a file as below: ## CONNECT mysql; CREATE TABLE maildb ( i