First page Back Continue Last page Image

What is a MySQL User variable

A User Variable is a MySQL Variable Type that is globally available (Global Scope) for the current user. Multiple procedures can make use of this variable and other users cannot see this variable

Instance of Procedure 1

Instance of Procedure 2

Instance of Procedure 3

Instance of Procedure 4

Instance of Procedure 5

Instance of Procedure 6

Instance of Procedure 7

Instance of Procedure 8

Users

Scope of User Variable

A user variable is preceded with an @