insert into student values(1,'A');
insert into student values(2,'B');


insert into phone_hot values(1,'0000003');
insert into phone values(1,'0000003');

start transaction;
insert into phone_hot values(1,'0000004');
insert into phone values(1,'0000004');
commit;

insert into phone values(1,'0000005');

update phone_hot set id='0000005' where s_id=1;

delete from phone where id='0000004';

delete from phone where id='0000005';
delete from phone_hot where s_id=1;

start transaction;
delete from phone where id='0000005';
delete from phone_hot where s_id=1;
commit;
