Despite my review of the manual, I cannot get my SELECT AS statements to work. Every attempt returns Error 1064. My statements, which appear to be in accordance with the manual (http://www.mysql.com/doc/en/SELECT.html), are formed as below. I have included my with my CREATE TABLE record for reference.
SELECT item_name AS name, item_desc AS desc FROM food; SHOW CREATE TABLE food; | food | CREATE TABLE `food` ( `item_id` tinyint(3) unsigned NOT NULL auto_increment, `cat_id` tinyint(3) unsigned NOT NULL default '0', `item_name` char(50) NOT NULL default '', `item_desc` char(255) NOT NULL default '', `item_price` decimal(5,2) NOT NULL default '0.00', PRIMARY KEY (`item_id`), KEY `idx_cat` (`cat_id`) ) TYPE=MyISAM | If I'm overlooking something simple, I apologize, but this just isn't working for me. Thanks a lot. Edward Dudlik Becoming Digital www.becomingdigital.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
