|
|
|
|
|
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. |
|