At 5:11 PM -0700 8/26/99, Steve Edberg wrote:
>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
>>>
>>> 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
It can also be used as an abbreviation of DESCRIBE.
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
