Re:Other things... (Score 1)

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.