mysql @的意思,MySQL，@@是什么意思？

最新推荐文章于 2024-07-23 19:00:53 发布

weixin_39943370

最新推荐文章于 2024-07-23 19:00:53 发布

阅读量536

点赞数

文章标签： mysql @的意思

这篇博客介绍了MySQL中系统变量与用户定义变量的区别。@@符号用于表示系统变量，如@@hostname，它区分全局和会话值。而@则用于用户定义的变量，如@hostname。在表达式中引用系统变量不指定@@global或@@session时，MySQL返回会话值（如果存在），否则为全局值。SET语句总是针对会话变量。

摘要由CSDN通过智能技术生成

I am reading the MySQL documentation, on this page http://dev.mysql.com/doc/refman/5.1/en/set-statement.html it often uses "@@", but does not define what "@@" means?

Another example is in variable names

mysql> select @@hostname;

+------------+

| @@hostname |

+------------+

| server1 |

+------------+

1 row in set (0.00 sec)

mysql> select @hostname;

+-----------+

| @hostname |

+-----------+

| NULL |

+-----------+

1 row in set (0.00 sec)

What is @ vs @@?

解决方案

@@ - System Vaiable

@@ is used for system variables. Using different suffix with @@, you can get either session or global value of the system variable.

When you refer to a system variable in an expression as @@var_name (that is, when you do not specify @@global. or @@session.), MySQL returns the session value if it exists and the global value otherwise. (This differs from SET @@var_name = value, which always refers to the session value.)

@ - User Defined Variable

while @ is used for user defined variables.

More Details