Field name DESC

2006-07-13 Thread Anthony
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... -- MySQL General Mailing List For list archives:

Re: Field name DESC

2006-07-13 Thread Alec . Cawley
to change the field name e.g. to descr or even description. Making the field name longer and more meaningful costs next to nothing. Alec Anthony [EMAIL PROTECTED] 13/07/2006 16:42 To mysql@lists.mysql.com cc Subject Field name DESC Hello, i want to know how i can create a table

Re: Field name DESC

2006-07-13 Thread Saline Erik
How about desc_ ? Erik On Jul 13, 2006, at 8:42 AM, 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...

Re: Field name DESC

2006-07-13 Thread Miles Thompson
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

re[2]: Field name DESC

2006-07-13 Thread Rob Desbois
. Alec Anthony [EMAIL PROTECTED] 13/07/2006 16:42 To mysql@lists.mysql.com cc Subject Field name DESC 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