4 ms·
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 the
by takeda 9y 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.