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

This article mainly introduces "what is the difference between = and: = in MySQL grammar". In daily operation, I believe that many people have doubts about the difference between = and: = in MySQL grammar. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "what is the difference between = and: = in MySQL grammar"! Next, please follow the editor to study!

The difference between = and: = in MySQL syntax

For programmers new to mysql, there will be questions about these two symbols, because you will find that some code uses one or the other. Of course, they are different. The difference between them is relatively simple:

": =" is a true assignment operation, with the variable on the left set to the value on the right.

"=" is only used as an assignment in two cases. The first is in the SET statement, SET var = value.

The other is the SET in the UPDATE statement, such as update table_name set column_name where.....

Except for these two cases, "=" is used as a comparison operator.

At this point, the study of "what's the difference between = and: = in MySQL grammar" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!