最近、遅刻が多いえのちゃん。
お昼の食費も多いえのちゃん。
今日はphpの授業でmysqlのデータベースでviewとかやった。
こんな感じ。
mysql> select * from tb; +------+------+------+ | bang | uri | tuki | +------+------+------+ | A103 | 90 | 4 | | A102 | 54 | 5 | | A104 | 180 | 4 | | A101 | 184 | 4 | | A103 | 17 | 5 | | A101 | 300 | 5 | | A102 | 205 | 6 | | A104 | 93 | 5 | | A107 | 87 | 6 | | A103 | 12 | 6 | +------+------+------+ 10 rows in set (0.00 sec) mysql> select * from tb where uri>100; +------+------+------+ | bang | uri | tuki | +------+------+------+ | A104 | 180 | 4 | | A101 | 184 | 4 | | A101 | 300 | 5 | | A102 | 205 | 6 | +------+------+------+ 4 rows in set (0.00 sec) mysql> create view tb_tbeno as select * from tb where uri>100; Query OK, 0 rows affected (0.02 sec) mysql> select * from tb_tbeno; +------+------+------+ | bang | uri | tuki | +------+------+------+ | A104 | 180 | 4 | | A101 | 184 | 4 | | A101 | 300 | 5 | | A102 | 205 | 6 | +------+------+------+ 4 rows in set (0.00 sec)
これでいつでも君はview出来る!
えのちゃんも漫画家デビューしたい!(*ω*)