Learn SQL Database Programming

Chapter 12

1. A stored query.
2. Yes, depending on the query in the view. You can update, insert, and delete from a view if it queries one table. You can insert and update from a view if queries multiple tables, but you can't delete.

3. It lets you store a single data value that can be used during your session's queries.
4. One of two ways:

• SET @varname = value;
• SET @varname := value;

5. A set of SQL statements stored in the database.
6. The main difference between a variable and parameter is that parameters are static throughout the procedure, but a variable can be changed during the stored procedure.
7. IF, CASE, LOOP, REPEAT, WHILE, ITERATE, and LEAVE.
8. These are a way to extend the functionality of MySQL, and they work much the same other built-in ...