最近、遅刻が多いえのちゃん。

お昼の食費も多いえのちゃん。
今日は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出来る！
えのちゃんも漫画家デビューしたい！（*ω*）