| 9. 1. 1. A few things aren't allowed in a query that defines a view |
|
|
A view definition cannot contain a subquery in the FROM clause of the SQL statement. |
User, system, or local variables are not allowed in the SQL SELECT statement. |
Views can't point at temporary tables. |
Triggers cannot be associated with a view. |
Views created within stored procedures can't reference parameters in the stored procedure. |
Quote from Pro MySQL |
by Michael Kruckenberg (Author), Jay Pipes (Author) |
# Paperback: 768 pages |
# Publisher: Apress (July 25, 2005) |
# Language: English |
# ISBN-10: 159059505X |
# ISBN-13: 978-1590595053 |