Hello Odhiambo,
Seems like From and To are MySQL reserved words.
http://www.mysql.com/doc/R/e/Reserved_words.html
Thanks,
Sherwin Ang
Web Programmer / Systems Administrator
Alchemy Solutions
http://www.alchemy.com.ph
Creative. Technology.
Tridel Technologies, Inc.
7th Floor Hanston Building
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
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
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
