MySql snacks-1. value assignment operators & quot; = & quot; and & quot;: _ MySQL

MySql snacks-1. value assignment operators: amp; quot; and amp; quot;: amp; quot; bitsCN.com
For programmers who have just come into contact with mysql, they may have doubts about these two symbols, because some codes use the other one.

Of course they are different. Their difference is also relatively simple: ": =" is a true value assignment operation, the left variable is set to the right value. "=" Is used as a value assignment only 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 .....

In addition to the two cases, "=" is used as a comparison operator. BitsCN.com