At 12:42 PM 7/13/2006, Anthony wrote:
Hello,
i want to know how i can create a table with the feild name "desc" ?
when i do:
CREATE TABLE bank (
name varchar(50) NOT NULL default '',
desc varchar(50) NOT NULL default '',
)
the desc is badely interpreted...
In a word - DON'T. "DESC" is a reserved word - if it is an abbreviation
for description, use "descr", if for descending, try "dscnd".
Use of reserved words for field names is bad practice and is guaranteed to
cause grief in the future.
Cheers - Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.9.10/387 - Release Date: 7/12/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]