At 22:23 -0700 1/28/02, Colin Faber wrote:
>If you MUST use date as the column name escape it with forward ticks,
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 'from
Which indicates that "from" is the word that MySQL's complaining about.
FROM is a reserved word. DATE is the name of the column type, but it
can be used as a column name as well.
Nevertheless, Colin's solution should work, except I think they're called
backticks. :-) Use `from` rather than just from as the column name.
Better yet, pick another name so you don't have to mess with the backticks.
>> On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington
>> >>Please forgive my bad step of joining the list and begining with
>> >>I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to
>> >>I am trying to create a table and made a file as below:
>> I believe the column name your using "date" is a reserved word in MySQL
>> Thunder Rain Internet Publishing
>> Providing Internet Solutions that work!
>> Tel: 1(225)686-2002
> > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=