MySQL 的 CREATE VIEW

剛剛在弄 CyrusBackend Database 用 MySQL 5.0.0,在設定 table 時我突然想到應該將 table 拆散,用 CREATE VIEWJOIN 建立一個大的 table,一方面是彈性問題,一方面是 performance 著想。

結果剛剛才在 C.1.2 Changes in release 5.0.1 (27 Jul 2004) 看到:

Added support for read-only and updatable views based on a single table or other updatable views. View use requires that you upgrade your grant tables to add the view-related privileges. See section 2.5.8 Upgrading the Grant Tables.

目前只有支援 single table… 看起來我要的功能還要等很久呢 :p