Variables

Use variables inside stored procedures — declaring them, assigning values with SET and SELECT, using them in procedure logic, their scope and lifetime, common patterns, and MySQL syntax.