From: Martijn Tonies
Date: November 11 2005 8:42am
Subject: Re: Does MySQL Support '=' Sign?
List-Archive: http://lists.mysql.com/mysql/191550
Message-Id: <010101c5e69b$e19c6690$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> > 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