事物 :操作序列
原子性: all or none的关系
事物管理的sql语句
set transaction {read only| read write}
savepoint name:保存点 可以回滚到保存点
commit work :提交 删除保存点 删除锁
rollback to savepoint name:回滚到保存点name
begain是数据库差异的
实例:
set transaction read write
update Dept set manager='ikeel' where no='111'
savepoint dept_savepoint
update salary set salary=salary*2 where ename='ikeel'
commit
封锁机制:
并发控制采取的方法。表级别的。
Lock table tbname in {share |excutive}
原子性: all or none的关系
事物管理的sql语句
set transaction {read only| read write}
savepoint name:保存点 可以回滚到保存点
commit work :提交 删除保存点 删除锁
rollback to savepoint name:回滚到保存点name
begain是数据库差异的
实例:
set transaction read write
update Dept set manager='ikeel' where no='111'
savepoint dept_savepoint
update salary set salary=salary*2 where ename='ikeel'
commit
封锁机制:
并发控制采取的方法。表级别的。
Lock table tbname in {share |excutive}