Re: Query fails

2001-08-26 Thread Jason Brooke
> CREATE TABLE MSJOURNL (ACCT INT(3), > DESC CHAR(29), > DTE DATE) > > This query fails when MySQL encouters DESC. Changing DESC to DESCRIP causes > the query to work. I'm wondering if filtering for the reserved word DESCRIBE > causes DESC not to be legal for use in field names? desc itself is a

Re: Query fails

2001-08-26 Thread Jeremy Zawodny
On Sun, Aug 26, 2001 at 01:58:23PM -0700, Bill Angus wrote: > CREATE TABLE MSJOURNL (ACCT INT(3), > DESC CHAR(29), > DTE DATE) > > This query fails when MySQL encouters DESC. Changing DESC to DESCRIP > causes the query to work. I'm wondering if filtering for the > reserved word DESCRIBE causes DE

RE: Query fails

2001-08-26 Thread Venu
Hi !! )-Original Message- )From: Bill Angus [mailto:[EMAIL PROTECTED]] )Sent: Sunday, August 26, 2001 1:58 PM )To: [EMAIL PROTECTED] )Subject: Query fails ) ) )CREATE TABLE MSJOURNL (ACCT INT(3), )DESC CHAR(29), )DTE DATE) ) )This query fails when MySQL encouters DESC. Changing DESC to DE