At 02:26 PM 8/26/1999 , Sweeney, Darren L wrote:
>
>
>This works:
>
>create table main (
>BatchID CHAR(8),
>Descr CHAR(20),
>BatchDate DATETIME
>);
>
>(added another letter changing Desc to Descr)
>
>Darren
>
>> -----Original Message-----
>> From: Denis Voitenko [SMTP:denis@stripped]
>> Sent: Thursday, August 26, 1999 5:22 PM
>> To: mysql
>> Subject: what is wrong with this?
>>
>> create table main (BatchID CHAR(8), Desc CHAR(20), BatchDate DATETIME); ?
>>
>> for some reason it gives an error which I can not find.
>>
>>
I ran into this problem before, too...DESC is a reserved word (used in
ORDER BY clauses); see list of MySQL reserved words at
http://www.mysql.com/Manual_chapter/manual_Reference.html#Reserved_words
-steve
+-------------------- "He's dead, Jim" - Bones McCoy --------------------+
| Steve Edberg University of California, Davis |
| sbedberg@stripped http://aesric.ucdavis.edu/ |
| (530)754-9127 |
+---------------------- DeForest Kelley 1920-1999 -----------------------+
