List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 7 2001 2:08am
Subject:Re: Table Creation woes
View as plain text  
At 5:52 PM -0400 6/6/01, Matt \"TrollBoy\" Wiseman wrote:
>can someone tell me what I'm doing wrong here?    I keep getting the error
>"You have an error in your SQL syntax near 'describe text, fulltext text,
>section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6" and I don't
>understand why:

DESCRIBE is a keyword.

>
>CREATE TABLE article(
>id INT (4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
>title VARCHAR (128) DEFAULT '0',
>logosmall VARCHAR (128) DEFAULT '0',
>logolarge VARCHAR (128) DEFAULT '0',
>describe text,
>fulltext text,
>section VARCHAR (32) DEFAULT '0',
>type VARCHAR (32) DEFAULT '0',
>PRIMARY KEY(id),
>UNIQUE(id)
>);
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread75781@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Paul DuBois, paul@stripped
Thread
Failures of two self tests.mtiernan6 Jun
  • Table Creation woesMatt \"TrollBoy\" Wiseman6 Jun
    • Re: Table Creation woesPaul DuBois7 Jun
    • RE: Table Creation woesChris Bolt7 Jun
  • Re: Table Creation woesJorge del Conde7 Jun
  • Re: Table Creation woesRolf Hopkins7 Jun