Professional Web Applications Themes

Explain := - MySQL

I tried seaching Google and the MySQL doentation 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...

  1. #1

    Default Explain :=

    I tried seaching Google and the MySQL doentation 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 Guest

  2. #2

    Default Re: Explain :=

    On Thu, 08 Mar 2007 20:03:31 GMT, Lee Peedin wrote: 

    Where'd you see the reference? I'm not recalling the usage since
    recycling most of the Pascal-inhabited braincells...

    --
    Don't even get me started on the MCSEs I know. It's a miracle of
    modern technology that some of these fsckwits still draw breath,
    much less a paycheck.
    -- Marc Bowden
    Peter Guest

  3. #3

    Default Re: Explain :=

    Lee Peedin wrote: 

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


    Paul Guest

  4. #4

    Default Re: Explain :=

    Lee Peedin <rr.com> wrote:
     

    http://dev.mysql.com/doc/refman/5.0/en/user-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
    Rik Guest

  5. #5

    Default Re: Explain :=

    On Thu, 08 Mar 2007 22:08:17 +0100, Rik <com>
    wrote:
     
    >
    >http://dev.mysql.com/doc/refman/5.0/en/user-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: =[/ref]


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

  6. #6

    Default Re: Explain :=

    On Thu, 8 Mar 2007 14:54:19 -0600, "Peter H. Coffin"
    <com> wrote:
     
    >
    >Where'd you see the reference? I'm not recalling the usage since
    >recycling most of the Pascal-inhabited braincells...[/ref]

    In using CASE statements.

    Lee
    Lee Guest

Similar Threads

  1. How do I explain?
    By Nicholas M in forum Macromedia Dynamic HTML
    Replies: 4
    Last Post: August 16th, 07:25 PM
  2. Can anyone explain this to me?
    By ericMorcombe in forum Dreamweaver AppDev
    Replies: 2
    Last Post: April 25th, 11:43 PM
  3. Please Explain
    By Waris Mirza in forum PERL Beginners
    Replies: 0
    Last Post: November 5th, 04:59 AM
  4. Replies: 4
    Last Post: September 15th, 06:11 PM
  5. can someone explain...
    By Jswalter in forum PHP Development
    Replies: 1
    Last Post: September 1st, 08:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139