Thank you much.  I don't know why that didn't occur to me.  :)

Edward Dudlik
Becoming Digital
www.becomingdigital.com


----- Original Message ----- 
From: "Jim Winstead" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, 09 June, 2003 22:18
Subject: Re: Trouble with SELECT AS syntax


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]





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

Reply via email to