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 |