SET ? DECLARE
http://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
http://dev.mysql.com/doc/refman/5.7/en/set-variable.html
SET Syntax for Variable Assignment
Local Variable DECLARE Syntax
var_name
var_name
type
value
variable_assignment
variable_assignment
variable_assignment
user_var_name
expr
param_name
expr
local_var_name
expr
system_var_name
expr
system_var_name
expr
SET
syntax for variable assignment enables you to assign values to different types of variables that affect the operation of the server or clients:
-
System variables. See Section 6.1.5, “Server System Variables”. System variables also can be set at server startup, as described in Section 6.1.6, “Using System Variables”. (To display system variable names and values, use the
SHOW VARIABLES
statement; see Section 14.7.5.39, “SHOW VARIABLES Syntax”.) -
User-defined variables. See Section 10.4, “User-Defined Variables”.
-
Stored procedure and function parameters, and stored program local variables. See Section 14.6.4, “Variables in Stored Programs”.
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步