List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:August 27 1999 12:11am
Subject:RE: what is wrong with this?
View as plain text  
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 -----------------------+
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