Search

Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 691 to 695 of 695 total results
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
Before MySQL 5.7.7, subqueries cannot be used in the FROM clause of a view. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view.
https://dev.mysql.com/doc/refman/5.7/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...