List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 27 1999 2:23am
Subject:RE: what is wrong with this?
View as plain text  
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/
Thread
what is wrong with this?Denis Voitenko26 Aug
  • Re: what is wrong with this?Patrice Bulat26 Aug
  • RE: what is wrong with this?Brian Andrews26 Aug
RE: what is wrong with this?Darren L Sweeney26 Aug
  • BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
      • Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
          • OT Re: BOOK (MySQL + mSQL) is *not* for dummiesjohn27 Aug
            • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesPaul DuBois27 Aug
          • Re: OT Re: BOOK (MySQL + mSQL) is *not* for dummiesGarrick Staples27 Aug
        • Re: BOOK (MySQL + mSQL) is *not* for dummiesDick Griffin27 Aug
          • Re: BOOK (MySQL + mSQL) is *not* for dummiesDerek Sivers27 Aug
      • damn root - why do you need to pee?Derek Sivers27 Aug
        • Re: damn root - why do you need to pee?Paul DuBois27 Aug
          • Re: damn root - why do you need to pee?Derek Sivers27 Aug
            • Re: damn root - why do you need to pee?Paul DuBois27 Aug
              • 0 rows affectedDerek Sivers27 Aug
                • 0 rows affectedJani Tolonen27 Aug
                • 0 rows affectedsinisa27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummieskg27 Aug
    • Re: BOOK (MySQL + mSQL) is *not* for dummiesWayne Topa27 Aug
  • RE: what is wrong with this?Steve Edberg27 Aug
    • RE: what is wrong with this?Paul DuBois27 Aug
  • Re: BOOK (MySQL + mSQL) is *not* for dummiesChris Shenton27 Aug