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]

Reply via email to