User Defined Variables « Select Query « MySQL Tutorial






  1. MySQL Tutorial
  2. Select Query
  3. User Defined Variables
2.22.User Defined Variables
2.22.1.User variables are written as @var_name.
2.22.2.You can also assign a value to a user variable in statements other than SET
2.22.3.Using User-Defined Variables
2.22.4.Use user-defined variable in the where statement
2.22.5.Create dynamic sql command