create table `table1` (
  id int primary key,
  name varchar(100)
) engine = innodb;

create table `table2` (
  pid int,
  name2 varchar(100),
  constraint `fk_table_1_2` foreign key (`pid`) references `table1`(`id`) on update cascade on delete cascade
) engine = innodb;


insert into `table1` values (1, 'Tester');
insert into `table1` values (2, 'Tester2');
insert into `table1` values (3, 'Tester3');

insert into `table2` values (1, 'Tester REF');
insert into `table2` values (2, 'Tester2 REF');
insert into `table2` values (3, 'Tester3 REF');

update `table1` set id = 4 where id = 2;

select * from `table2`;