mysql-error-1451
No se puede eliminar o actualizar una fila principal: falla una restricción de clave foránea
Al hacer:
DELETE FROM `jobs` WHERE `job_id` =1 LIMIT 1
Errores:
#1451 - Cannot delete or update a parent row: a foreig ... TABLE `advertisers`
ADD CONSTRAINT `advertisers_ibfk_1` FOREIGN KEY (`advertiser_id`) REFERENCES `jobs` (`advertiser_id`);