您的位置:首页 > 博客中心 > 数据库 >

SQL_保存事务

时间:2022-03-14 00:36

begin transaction
    insert into teachers (Name,Age,Greade) values(‘test1‘,40,‘高三三班‘)
    insert into Students (ClassName,Name,Age) values(‘高三六班‘,‘小花‘,18)
save transaction save1
    insert into teachers (Name,Age,Greade) values(‘test2‘,50,‘高三三班‘)
    insert into Students (ClassName,Name,Age) values(‘高三六班‘,‘阿紫‘,19)
rollback transaction save1
commit transaction

 

热门排行

今日推荐

热门手游