I'm using MySQL Workbench to update a record. Will error 1175 occur?

Responsive Ad Header

Question

Grade: Education Subject: Support
I'm using MySQL Workbench to update a record. Will error 1175 occur?
Asked by:
68 Viewed 68 Answers

Answer (68)

Best Answer
(225)
Yes, error 1175 can occur during updates if you're attempting to change the foreign key value to a value that doesn't exist in the referenced table's primary or unique key column. The constraint still applies during updates.