describe is a reserved word, use another name for the column.
http://www.mysql.com/doc/R/e/Reserved_words.html
> 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 '
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 reserved word and so is fulltext, I think.
- Original Message -
From: "Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 5:52
Subject: Table Creation woes
> can someone tell me what I&#x
t "TrollBoy" Wiseman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 4:52 PM
Subject: Table Creation woes
> can someone tell me what I'm doing wrong here?I keep getting the error
> "You have an error in your SQL syntax near
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:
CREATE TABLE article(
id INT (4) DEFAULT '0' NOT NULL AUTO_IN
