mysql.com/doc/refman/5.0/en/create-view.html).
A click on Go generates the view we asked for.
The CHECK OPTION clause influences the behavior of updateable views (this is
explained in the MySQL manual at http://dev.mysql.com/doc/refman/5.0/en/
create-view.html).
MySQL 5.0 Features
[ 270 ]
Renaming a View
phpMyAdmin 2.11.0 does not support this directly from the interface, however, since
MySQL 5.0.14, the RENAME TABLE statement can be used (from a phpMyAdmin's
query box) as long as we are renaming inside the same database. For example,
RENAME TABLE book_public_info TO book_public_info2.
Performance Hint
Since version 2.10, phpMyAdmin uses a new configuration parameter, $cfg['MaxEx
actCountViews'], that acts as a limit for 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.
If we nonetheless prefer to see a more exact row count for views, we can put a larger
value in this parameter, which acts as an upper limit for the rows counting phase.
Pages:
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247