Midhat
Reputation: 17820
`@` Symbol in mysql variable names
I have started maintaining a bunch of mysql stored procs. Some variables (created with decalare statements) are accessed with the @ symbol and others without it. Whats the difference
Upvotes: 1
Views: 2085
Answers (1)
KV Prajapati
Reputation: 94643
A variable with the @ at the beginning is session variable. It exists until the session end.
Upvotes: 3
Related Questions
- MySQL: @variable vs. variable. What's the difference?
- MySQL variable name conflicts with field name
- Declare @ variable in SQL returning an error
- Difference between declare @variablename and declare variablename while working with stored procedures
- mysql stored procedure parameters don't seem to work with "@" (At sign)
- MySQL stored procedure @ syntax error
- "@" symbol in stored procedure?
- What does the @ symbol means on a Procedure in MySQL?
- MySQL '@': what does it do?
- How do I use the @ sign in Mysql?