User vs. local variables

A MySQL expert describes the difference between user variables and local variables.

What is the difference between user variables and local variables?

Local variables refer to variables declared within a stored routine. Their scope is limited to the BEGIN and END

block in which they are declared.

User variables are named with the @ symbol, and have global scope within the connection (you can set them inside a stored procedure, and still access them after the procedure has finished, for example).

This was first published in June 2007

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: