2007-01-13から1日間の記事一覧
mysql> DROP VIEW v_test; Query OK, 0 rows affected (0.00 sec)
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_to…