mysql-进阶 视图

<?php 
//bank原表
+-----+-----------+---------+
| bid | name      | money   |
+-----+-----------+---------+
|   1 | A         |    0.00 |
|   2 | B         | 1000.00 |
|   3 | jobs      |    1.00 |
+-----+-----------+---------+


//创建bank_view视图，不让看money这个敏感的字段
create view bank_view as select bid,name from bank;
//查看视图
show table status where comment=‘VIEW‘;
//显示视图
select * from view_bank;
//删除视图
drop view bank_view;
//修改视图，只让看bid
alter view bank_view as select bid from bank;


?>