1

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

Midhat
  • 17,454
  • 22
  • 87
  • 114
  • and why does the title of this question starts wiht "stored procedures" instead of "mysql", as it is clearly the more important tag – Midhat Dec 21 '10 at 10:06
  • possible duplicate of [MySQL: @variable vs. variable. Whats the difference?](http://stackoverflow.com/questions/1009954/mysql-variable-vs-variable-whats-the-difference) – KV Prajapati Dec 21 '10 at 10:13

1 Answers1

3

A variable with the @ at the beginning is session variable. It exists until the session end.

Community
  • 1
  • 1
KV Prajapati
  • 93,659
  • 19
  • 148
  • 186