'desc' and column names

2002-02-01 Thread vinko
Description: If you create a table with a column name called 'desc' (as the command, that is, without the '') mysql allows to create it, but then you can't query or do any operation with it, always giving an error like: You have an error in your SQL syntax near

Re: 'desc' and column names

2002-02-01 Thread Gerald Clark
'desc' is a reserved word. If you insist on using it for a field name, enclose it in back-ticks: `desc` [EMAIL PROTECTED] wrote: Description: If you create a table with a column name called 'desc' (as the command, that is, without the '') mysql allows to create it, but then you