REGEXP is Case Sensitive?
According to MySQL documentation: MySQL :: MySQL 8.0 Reference Manual :: 12.8.2 Regular Expressions. match_type may be specified with the c or i characters to… Read More »REGEXP is Case Sensitive?
Trigger
How to Resolve ERROR 1359 (HY000): Trigger already exists
Let's reproduce the error.mysql> use db1Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup… Read More »How to Resolve ERROR 1359 (HY000): Trigger already exists
How to Resolve ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger
You might think you can set new values of columns on the new row after inserting in a trigger, but you can't: mysql> delimiter //… Read More »How to Resolve ERROR 1362 (HY000): Updating of NEW row is not allowed in after trigger
How to Resolve ERROR 1442 (HY000): Can't update table in stored function/trigger
ERROR 1442 (HY000) The following examples are trying to create triggers to update some data in current table at event AFTER INSERT. Trigger #1: CREATE… Read More »How to Resolve ERROR 1442 (HY000): Can't update table in stored function/trigger