云山漫卷

摘要： 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... 阅读全文