qq_44516871的博客

五、视图的更新 #五、视图的更新 CREATE OR REPLACE VIEW myv1 as select last_name,email,salary*12*(1+ifnull(commission_pct,0)) "annual salary" from employees; select * from myv1;#查看视图myv1 #1.插入 insert into myv1 value...