undefined | Better HN

0 pointsblhack16y ago0 comments

MySQL DOES have support for foreign keys.

create table foo (blah, blah, blah) engine = innodb

Sorry, I'm not trying to start an argument. That sentence just struck me as a bit inflammatory.

0 comments

3 comments · 1 top-level

modoc16y ago· 2 in thread

The GP's point is that the default engine, and hence the one used by probably 90+% of people using MySQL doesn't support FKs and other "standard" data integrity features that you wouldn't even know to ask about, since every other major db supports them by default.

Plus if you try to create an FK on a myisam backed table it happily runs the SQL, without errors, and you think you have a working FK.

jfarmer16y ago

It's more like the "default default" -- you can change it so, by default, every table is created using InnoDB. IIRC, MySQL comes with an example config that demonstrates just that.

staunch16y ago

I'd bet 90%+ of companies using MySQL for anything serious are using InnoDB.

j / k navigate · click thread line to collapse