Re: Trouble with SELECT AS syntax

[Jim Winstead]

On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote:
> SELECT item_name AS name, item_desc AS desc FROM food;

'desc' is a reserved word.

Try: 

  SELECT item_name AS name, item_desc AS `desc` FROM food;

Jim Winstead
MySQL AB

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]