The SET
statement has several forms. SET
语句有几种形式。Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section:与特定服务器功能无关的表单的说明见本节的小节:
SET
var_name
= value
enables you to assign values to variables that affect the operation of the server or clients. 允许您将值分配给影响服务器或客户端操作的变量。See Section 13.7.6.1, “SET Syntax for Variable Assignment”.请参阅第13.7.6.1节,“用于变量赋值的SET语法”。
SET CHARACTER SET
and 和SET NAMES
assign values to character set and collation variables associated with the current connection to the server. 为与服务器当前连接关联的字符集和排序规则变量赋值。See Section 13.7.6.2, “SET CHARACTER SET Statement”, and Section 13.7.6.3, “SET NAMES Statement”.请参阅第13.7.6.3节,“SET NAMES语句”。
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement:其他表单的描述显示在其他地方,与其他与它们帮助实现的功能相关的语句一起分组:
SET DEFAULT ROLE
and 和SET ROLE
set the default role and current role for user accounts. 设置用户帐户的默认角色和当前角色。See Section 13.7.1.9, “SET DEFAULT ROLE Statement”, and Section 13.7.1.11, “SET ROLE Statement”.请参阅第13.7.1.9节,“SET DEFAULT ROLE语句”和第13.7.1.11节,“SET ROLE语句”。
SET PASSWORD
assigns account passwords. 分配帐户密码。See Section 13.7.1.10, “SET PASSWORD Statement”.请参阅第13.7.1.10节,“SET PASSWORD语句”。
SET RESOURCE GROUP
assigns threads to a resource group. 将线程分配给资源组。See Section 13.7.2.4, “SET RESOURCE GROUP Statement”.请参阅第13.7.2.4节,“SET RESOURCE GROUP语句”。
SET TRANSACTION ISOLATION LEVEL
sets the isolation level for transaction processing. 设置事务处理的隔离级别。See Section 13.3.7, “SET TRANSACTION Statement”.请参阅第13.3.7节,“SET TRANSACTION语句”。