> > 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, I'm unsure if this is the same. In MS SQL, using the above construct defines a column alias. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]