-
MySQL Dim sum-1, assignment operator "=" and ": ="
-
for programmers who have just come into contact with MySQL, the two symbols will be questioned, because they will find that some of the code used in the other.
Of course they are different. Their difference is simple: ": =" is the real assignment operation, the left variable is set to the right value. Www.2cto.com "=" is used only in two cases as the assignment, 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 .....
The "=" is used as a comparison operator in addition to the aspects of these two cases.
Assignment Operation
Select @nextid: = ID from Goods.idmaker;
Set @goodsid = @nextid;
Set @cate1id = @goodsid +1;
The @goodsid can be used in SQL statements
MYSQL 1, assignment operator "=" and ": ="