DECLARE variable_name datatype(size) [DEFAULT default_value]; … DECLARE totalSale DEC(10,2) DEFAULT 0.0; … DECLARE x, y INT DEFAULT 0; … SET variable_name = value; … DECLARE total INT DEFAULT 0; SET total = 10;

How do you DECLARE a variable in a procedure?

Variables in SQL procedures are defined by using the DECLARE statement. Values can be assigned to variables using the SET statement or the SELECT INTO statement or as a default value when the variable is declared. Literals, expressions, the result of a query, and special register values can be assigned to variables.

How do you SET a variable in MySQL query?

The syntax for assigning a value to a SQL variable within a SELECT query is @ var_name := value , where var_name is the variable name and value is a value that you’re retrieving. The variable may be used in subsequent queries wherever an expression is allowed, such as in a WHERE clause or in an INSERT statement.