What is the difference between ":" and "=" in MySQL

Editor to share with you what is the difference between "=" and "=" in MySQL, I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

=

It is only in set and update that it is the same as: =, the function of assignment is equal to that of others. In view of this, when you implement a line number with a variable, you must use: =.

: =

The role of constant assignment is not only in set and update, but also in select.

The following is the comparison of the effects of = and = in select under   

Sql

Set @ num = 0scape select @ num: = @ num+1 AS rowno, nc as nickname from table_user

Result

Sql

Set @ num = 0scape select @ num = @ num+1 AS rowno, nc as nickname from table_user

Result

Sql

Set @ num = 0scape select @ num = @ num AS rowno, nc as nickname from table_user

Result

The above is all the contents of the article "what's the difference between" and "=" in MySQL. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!