MySQL视图基本操作(2)

修改基于多表创建的视图

mysql> insert into cus_bal(cusname,bal) values ("ee",11); ERROR 1393 (HY000): Can not modify more than one base table through a join view 'rms.cus_bal' 删除视图

删除视图cus_bal

drop view cus_bal; mysql> drop view cus_bal; Query OK, 0 rows affected (0.00 sec)

Linux公社的RSS地址：https://www.linuxidc.com/rssFeed.aspx