Answers for "error 145"

SQL
0

error code 1451 sql

SET FOREIGN_KEY_CHECKS=0;
Now you can fire your query.
DELETE FROM TABLE WHERE ID = 'Somthing';
You can enable foreign key again
SET FOREIGN_KEY_CHECKS=1;
Posted by: Guest on August-27-2021
0

mysql error 1452

SELECT child_table.* 
FROM child_table 
LEFT JOIN parent_table 
  ON parent_table.referenced_column = child_table.referencing_column 
WHERE parent_table.referenced_column IS NULL


-- Delete all data from output of that query
Posted by: Guest on August-28-2020

Code answers related to "error 145"

Code answers related to "SQL"

Browse Popular Code Answers by Language