摘要: MySQL建视图:CREATE VIEW view_name AS SELECT * FROM table1;ALTER VIEW view_name AS SELECT * FROM table1;建触发器create trigger trig_namebefore insert on table_namefor each rowbegin insert into table2 set field2 = NEW.field1; delete from table3 where field3 = NEW.field1; update table4 set field4 = fie... 阅读全文
posted @ 2012-08-04 17:24 云山漫卷 阅读(223) 评论(0) 推荐(0) 编辑