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 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?
)
As per SQL-92, DESC and ASC are standard keywords. So, you can't use them in
the Data Defination statements.
Regards
Venu
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu <mailto:[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ Woodside, California USA
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
