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