Base de datos de Banco Con Commit

create database Bancos;
use Bancos;

create table sucursal(id_cuenta int primary key, id_usuarios_fk int, saldo int );
create table clientes (id_cliente int primary key, nombre_clie varchar(50),telefono varchar(15));

alter table sucursal add foreign key( id_usuarios_fk)
references clientes (id_cliente)
on update cascade on delete cascade;

insert into clientes values(1,"Armando","12345"),(2,"Pedro","12356"),(3,"Luz","14725");
insert into sucursal values(1,4,6000),(2,5,7000),(3,6,3000);

begin;
update sucursal set saldo = saldo + 2000 where id_cuenta=1;
commit;

select *from sucursal;
select * from clientes;

https://www.youtube.com/watch?v=Tgx1OpXcbzA&feature=youtu.be