Yes.
You can add on SELECT syntax the AS operation, like this:
SELECT
ads.id AS 'ads.id',
track.id AS 'track.id'
FROM .....
-----Original Message-----
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 2:42 PM
To: mysql@lists.mysql.com
Subject: Want mysql to return tablename.fieldname format
I am working with an existing compilcated query someone wrote years ago.
When I dump the data from the query to try to figure out why I'm getting
unexpected data, I have three fields named "id". Is there anyway to
tell mysql to name the fields with the table name when they are
returned, so they show up as ads.id, track.id, etc?
-Ryan
--
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]
