B.6. MySQL 5.5 FAQ: Views

Questions

  • B.6.1: Where can I find documentation covering MySQL Views?

  • B.6.2: Is there a discussion forum for MySQL Views?

  • B.6.3: What happens to a view if an underlying table is dropped or renamed?

  • B.6.4: Does MySQL 5.5 have table snapshots?

  • B.6.5: Does MySQL 5.5 have materialized views?

  • B.6.6: Can you insert into views that are based on joins?

Questions and Answers

B.6.1: Where can I find documentation covering MySQL Views?

See Section 19.5, “Using Views”.

B.6.2: Is there a discussion forum for MySQL Views?

Yes. See http://forums.mysql.com/list.php?100

B.6.3: What happens to a view if an underlying table is dropped or renamed?

After a view has been created, it is possible to drop or alter a table or view to which the definition refers. To check a view definition for problems of this kind, use the CHECK TABLE statement. (See Section 12.4.2.2, “CHECK TABLE Syntax”.)

B.6.4: Does MySQL 5.5 have table snapshots?

No.

B.6.5: Does MySQL 5.5 have materialized views?

No.

B.6.6: Can you insert into views that are based on joins?

It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved.

You cannot insert into multiple tables with a single insert on a view.

Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout