4 ms·
I'll add another one: * No Foreign Keys Attempting to clear the table should have just thrown a constraint violation error.
by mbell 14y ago
I'll add another one:
* No Foreign Keys
Attempting to clear the table should have just thrown a constraint violation error.
- jasonswett 14y agoExactly!!!!
- eloisant 14y agoWell, depending how you configure your cascade clearing the user table could have cleared all the other tables also :) "on delete cascade"!
- mbell 14y agoTrue on MySql with InnoDB, wouldn't be true with postgres. You'd have to use TRUNCATE CASCADE on postgres to avoid the foreign key error.