Database Reference
In-Depth Information
A click on Go generates the view we asked for.
The CHECK OPTION clause influences the behavior of the updateable views (this is
explained in the MySQL manual at the page cited previously).
Renaming a view
phpMyAdmin does not support renaming a view directly from the interface.
However, since MySQL 5.0.14, the RENAME TABLE statement has been allowed
to be used (from a phpMyAdmin's query box) as long as we are renaming inside
the same database. For example, RENAME TABLE book_public_info2 TO
book_public_info2 .
Performance hint
phpMyAdmin has a configuration parameter, $cfg['MaxExactCountViews'] , that
controls the rows counting phase of phpMyAdmin. Sometimes, a view comprises
many huge tables and browsing it would make a large number of virtual rows
appear. Therefore, the default value of 0 for this parameter ensures that no row
counting happens for views. In this case, we'll see rather strange results when
browsing a view: Showing rows 0 - -1 (0 total, Query took 0.0006 sec) . But this is
more acceptable than slowing down a server.
 
Search WWH ::




Custom Search