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
