Wow my data import went great without a hitch. Wait what's this? None of the check constraints were fired off? Referential constraints also went unchecked???
Then I found that you must explicitly tell mysql to act like a real database everytime you make a database connection. $dbh->do("set sql_mode='TRADITIONAL'");
Slashdot Mirror
Wow my data import went great without a hitch. Wait what's this? None of the check constraints were fired off? Referential constraints also went unchecked???
Then I found that you must explicitly tell mysql to act like a real database everytime you make a database connection.
$dbh->do("set sql_mode='TRADITIONAL'");
Apparently sql_mode='STUPID' is the default.