A user variable is: only available to the current user and cannot be seen or accessed by other users. able to store various data types including string, numeric, and date/time types. all of the above. available from statements coded both inside and outside of stored programs.
MySQL Workbench can help get you started writing scripts that create stored procedures and functions. When you select the Create Stored Procedures or the Create Stored Funcions node, MySQL Workbench automatically generates some basic code for the routine, including: a CREATE PROCEDURE statement. a DELIMITER statement.