List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 11 2005 8:42am
Subject:Re: Does MySQL Support '=' Sign?
View as plain text  
> > 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

Thread
Does MySQL Support '=' Sign?The Nice Spider11 Nov
  • Re: Does MySQL Support '=' Sign?SGreen11 Nov
    • Re: Does MySQL Support '=' Sign?Martijn Tonies11 Nov
      • Re: Does MySQL Support '=' Sign?SGreen11 Nov
        • Re: Does MySQL Support '=' Sign?Martijn Tonies11 Nov
  • Re: Does MySQL Support '=' Sign?Pooly11 Nov