Hacker News new | ask | show | jobs
by takeda 3185 days ago
I actually had databases class which used MySQL for exercises and essentially it was like this:

* you can configure triggers for a table, but you can't use them in MySQL unless you make sure the table is InnoDB (this was a while ago before defaults changed)

* MySQL doesn't support aborting INSERT/UPDATE/DELETE from trigger, but you can emulate it by throwing an exception

* a table can have a CHECK constraint, but you can't use it because it is not available in MySQL

Makes one wonder MySQL was picked for that class. I get that it was because it was very popular at the time, but it felt like a toy compared to a functionality that any other database had.