Get the App
SLTechnology News&Howtos  ›  Database  › 

What's the difference between @ and @ @ in MySQL?

Shulou Source: shulou.com Published: 2022-05-31 18:56:32 09月29日 Update

This article is mainly about "what's the difference between @ and @ @ of MySQL". Interested friends might as well take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what's the difference between @ and @ @ of MySQL"!

The difference between @ and @ @ in MySQL

@ x is a user-defined variable (User variables are written as @ var_name)

@ x is a global or session variable (@ @ global @ @ session)

Reference: 6.1.4 Server System Variables

Select @ @ log_error

Mysql > SET @ t1room0, @ t2room0, @ t3room0

Mysql > SELECT @ t1vision = (@ t2rang1) + @ t3purl 4jcgi t1jue t2jingt3

At this point, I believe you have a deeper understanding of "what's the difference between @ and @ @ of MySQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Tags: Content variables learning practical deeper interest practicality practicality simple operation methods more friends users websites channels references inquiries Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker Apple macOS Shulou Information Microsoft