mysql> ALTER VIEW v_test AS SELECT shcd,shname,tanka,kigou FROM t_syohin
-> WHERE tanka < 4000;
Query OK, 0 rows affected (0.01 sec)
mysql> SELECT * FROM v_test;
+--------+---------------------+-------+-------+
| shcd | shname | tanka | kigou |
+--------+---------------------+-------+-------+
| 100001 | USBメモリー128 | 2500 | USBM |
| 100002 | USBメモリー256 | 3500 | USBM |
| 100101 | SDメモリーカード128 | 2300 | SDMC |
| 100201 | スマートメディア32 | 1200 | SM |
| 100202 | スマートメディア64 | 2500 | SM |
+--------+---------------------+-------+-------+
5 rows in set (0.00 sec)