On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote:
No, you will have to "emulate" them using triggers or stored
procedures.
Or:
1. Create table "this_is_not_a_view" and use that as the materialized
view
2. Build a new version in the background "this_is_not_a_view_pending"
as per your data freshness requirements
3. Use RENAME TABLE to push the "pending" table to "production" so to
speak
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org