Hi James, You can update db by sql
Update vm_instance set last_host_id =NULL where last_host_id=12; -Wei On Tuesday, 7 September 2021, James Steele <jsteele.em...@gmail.com> wrote: > Thanks for that reply Jordan, > > when I did that, I got: > > mysql> delete from host where id=12; > ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key > constraint fails (`cloud`.`vm_instance`, CONSTRAINT > `fk_vm_instance__last_host_id` FOREIGN KEY (`last_host_id`) REFERENCES > `host` (`id`)) > mysql> > > Any idea? Thanks, Jim >
