Mega Code Archive

 

Categories / MySQL Tutorial / View

 

A few things arent 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