There is no collation or size associated with a view.
This creation step was done manually; other operations on views are handled by
phpMyAdmin's interface.
Right Panel and Views
Since a view has similarities compared to a table, its name is available in the
navigation panel, among the names of ordinary tables. After clicking on this view's
name, a panel similar to the one seen for tables is displayed, but with fewer menu
tabs than for a normal table. Indeed, some operations do not make sense on a view,
for example, Import, because a view does not really contain data, but other actions
are perfectly acceptable, such as Browse.
Let's browse this view:
MySQL 5.0 Features
[ 268 ]
We notice that in the generated SQL query, we do not see our original CREATE VIEW
statement. The reason is that we are selecting from the view, and this is done with
a SELECT statement, hiding the fact that we are pulling data from a view. However,
exporting the view's structure would display how MySQL internally stored our view:
CREATE ALGORITHM=UNDEFINED DEFINER='marc'@'%' SQL SECURITY DEFINER
VIEW `book_author` AS
select `book`.`isbn` AS 'isbn',
`book`.`title` AS 'title',
`author`.`name` AS 'name'
from (`book` left join `author` on((`book`.`author_id` = `author`.
`id`)));
The right panel's menu may look similar to the one for a table, but when needed,
phpMyAdmin generates the appropriate syntax for handling views.
Pages:
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245