The Nice Spider <[EMAIL PROTECTED]> wrote on 11/10/2005 09:40:31 PM: > Does MySQL support: > > SELECT ID_TAG= ID > FROM TABLE > > rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. > >
Within the SELECT statement you must use := If you were in a SET statement, you could use = or := http://dev.mysql.com/doc/refman/4.1/en/variables.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine