mysql> CREATE VIEW v_test AS SELECT shcd,shname,tanka,kigou FROM t_syohin;
Query OK, 0 rows affected (0.07 sec)
mysql> show tables;
+------------------+
| Tables_in_rensyu |
+------------------+
| members |
| t_hanbai |
| t_syohin |
| t_tokui |
| v_test |
+------------------+
5 rows in set (0.01 sec)
mysql> EXPLAIN v_test;
+--------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| shcd | varchar(6) | NO | | | |
| shname | varchar(40) | NO | | | |
| tanka | int(10) unsigned | NO | | 0 | |
| kigou | varchar(4) | NO | | | |
+--------+------------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
