Re: How to save a view?

[Arie Nagel]

From: http://dev.mysql.com/doc/mysql/en/create-view.html

mysql> CREATE TABLE t (qty INT, price INT);
mysql> INSERT INTO t VALUES(3, 50);
mysql> CREATE VIEW v AS SELECT qty, price, qty*price AS value FROM t;
mysql> SELECT * FROM v;
+------+-------+-------+
| qty | price | value |
+------+-------+-------+
| 3 | 50 | 150 |
+------+-------+-------+

See also: http://dev.mysql.com/doc/mysql/en/views.html