Explain :=

I tried seaching Google and the MySQL documentation for :=, but that
seems to be some special search code as Google return nothing and
MySQL returns a tutorial on how to use the search.

So was exactly is ":=" as compared to just "="?

Thanks
Lee

Lee Peedin wrote:
> I tried seaching Google and the MySQL documentation for :=, but that
> seems to be some special search code as Google return nothing and
> MySQL returns a tutorial on how to use the search.
>
> So was exactly is ":=" as compared to just "="?
>
> Thanks
> Lee

It's an assignment operator.
See http://dev.mysql.com/doc/refman/5.0/...variables.html

Lee Peedin <lpeedinDONOTSPAME@nc.rr.com> wrote:

> I tried seaching Google and the MySQL documentation for :=, but that
> seems to be some special search code as Google return nothing and
> MySQL returns a tutorial on how to use the search.
>
> So was exactly is ":=" as compared to just "="?

http://dev.mysql.com/doc/refman/5.0/...variables.html

It's an assignment operator in non-SET statements.

So, while in a lot of programming language, we have:

Assignment: =
Comparison: ==

In (My)SQL, it's:
Assignment: := or = in SET statements
Comparison: =
--
Rik Wasmus
Posted on Usenet, not any forum you might see this in.
Ask Smart Questions: http://tinyurl.com/anel

On Thu, 08 Mar 2007 22:08:17 +0100, Rik <luiheidsgoeroe@hotmail.com>
wrote:

>Lee Peedin <lpeedinDONOTSPAME@nc.rr.com> wrote:
>
>> I tried seaching Google and the MySQL documentation for :=, but that
>> seems to be some special search code as Google return nothing and
>> MySQL returns a tutorial on how to use the search.
>>
>> So was exactly is ":=" as compared to just "="?
>
>http://dev.mysql.com/doc/refman/5.0/...variables.html
>
>It's an assignment operator in non-SET statements.
>
>So, while in a lot of programming language, we have:
>
>Assignment: =
>Comparison: ==
>
>In (My)SQL, it's:
>Assignment: := or = in SET statements
>Comparison: =


Thanks Paul & Rik,
The page you both linked was in fact the only reference I could find
that even mentioned this and it was no more than a couple of lines
(quite hard to find).

This explaination is exactly what I was looking.

Lee

On Thu, 8 Mar 2007 14:54:19 -0600, "Peter H. Coffin"
<hellsop@ninehells.com> wrote:

>On Thu, 08 Mar 2007 20:03:31 GMT, Lee Peedin wrote:
>> I tried seaching Google and the MySQL documentation for :=, but that
>> seems to be some special search code as Google return nothing and
>> MySQL returns a tutorial on how to use the search.
>>
>> So was exactly is ":=" as compared to just "="?
>
>Where'd you see the reference? I'm not recalling the usage since
>recycling most of the Pascal-inhabited braincells...

In using CASE statements.

Lee