Error
SQL query: Copy
DELETE FROM regallub_qjobs.companies;
MySQL said:
#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`regallub_qjobs`.`company_questions`, CONSTRAINT `company_questions_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`)) ";s:11:"go_back_url";s:66:"index.php?route=/table/structure&db=regallub_qjobs&table=companies";}is_multi_query|b:0;sql_history|a:9:{i:0;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:1;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:2;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:3;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:4;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:10:"candidates";s:8:"sqlquery";s:26:"SELECT * FROM `candidates`";}i:5;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:6;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:7;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}i:8;a:3:{s:2:"db";s:14:"regallub_qjobs";s:5:"table";s:9:"companies";s:8:"sqlquery";s:25:"SELECT * FROM `companies`";}}errors|a:0:{}sql_from_query_box|b:1;