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
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...
DESC is a reserved word in MySQL: it is short for DESCENDING and is used
to reverse the sort order in SELECTs. You an create a field with that name
by enclosing it in backticks: `desc` whenever you need it. However, this
would be regarded by many as very bad practice. It would be better to
chan
