July 25, 2013

what's meaning of this mark ":=" in mysql?

User2495385’s Question:

I don’t know
What’s the meaning of this mark? := in MySQL
for example in Code.

  select @RN:=@RN+1 as no, ...
  from Employee
  where EmployeeNumber='stackoverflow'

thank you.

It is binded variable. It will referenced later on while executing the query.

Author: Nabin Nepal (Starx)

Hello, I am Nabin Nepal and you can call me Starx. This is my blog where write about my life and my involvements. I am a Software Developer, A Cyclist and a Realist. I hope you will find my blog interesting. Follow me on Google+


Please fill the form - I will response as fast as I can!