3 ms·
Are you sure mysql doesn't enforce foreign key constraints? I recently did a project with mysql backend and it did threw constraint errors on invalid inputs tha
by h2so4 9y ago
Are you sure mysql doesn't enforce foreign key constraints? I recently did a project with mysql backend and it did threw constraint errors on invalid inputs that didn't match a parent key record.
- wolph 9y agoYou're partially correct. It does when inserting or updating, but if you do an alter ignore table you can create foreign key constraints that are actually invalid. So... not in all cases