Variables
Local variables can be declared within stored procedures using the
DECLARE
statement. Variable names follow the same naming rules
as MySQL table column names and can be of any MySQL data type. You can
give variables an initial value with the DEFAULT
clause and assign them new values
using the SET
command, as shown in
Figure 2-5.
Get MySQL Stored Procedure Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.