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
>

Reply via email to