中国石油大学华东数据库实验六龚安.docVIP

实验六 其它数据库对象的管理 1. begin transaction insert into xiangmubiao values(zy2011006,112202002,y005,10000,张三,07-01-2011,07-04-2011,07-25-2011,作业公司作业一队,堵漏,7000,2500,1000,1400,11900,李四, 07-26-2011,11900,王五,07-28-2011); insert into cailiaofeibiao values(zy2011006,wm001,200,10); insert into cailiaofeibiao values(zwm002,200,10); insert into cailiaofeibiao values(zwm003,200,10); insert into cailiaofeibiao values(zwm004,200,10); rollback begin transaction go insert into xiangmubiao values(zy2011006,112202002,y005,10000,张三,07-01-2011,07-04-2011,07-25-2011,作业公司作业一队,堵漏,7000,2500,10