2007-01-28から1日間の記事一覧
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 | ki…