In SQL, the ":=" assignment operator is used to store the result of an expression in a specified variable. It immediately assigns the value of the expression on the right side of the equal sign to the variable on the left side of the equal sign. Additionally, := is available in any SQL statement (such as a stored procedure) and is an alias for the SET statement, but it cannot assign a value to a column or table.
The := operator in SQL
The := assignment operator in SQL is used in variables Store the value. The assignment operator stores the result of the expression on the right side of the equal sign in the variable specified on the left side of the equal sign.
Usage
:= The basic form of the syntax is:
1 |
|
where:
Example
The following query creates a variable named total_sales
, which stores the sales
table The sum of all sales:
1 2 |
|
Features
Notes
The above is the detailed content of What does := mean in sql. For more information, please follow other related articles on the PHP Chinese website!