表:
t1:
id name salaryt2:
age address视图:
create view as select t1.*,t2.* from t1,t2要求生成一个触发器,每往t1中插入一条记录时,就刷新一下视图.
t1:
id name salaryt2:
age address视图:
create view as select t1.*,t2.* from t1,t2要求生成一个触发器,每往t1中插入一条记录时,就刷新一下视图.
drop view 你的名字;
create view as select t1.*,t2.* from t1,t2;