REGEXP is Case Sensitive?October 6, 2015December 13, 2022According 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?
How to Resolve ERROR 1359 (HY000): Trigger already existsOctober 31, 2014Let'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 triggerMarch 6, 2014December 6, 2022You 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/triggerJuly 26, 2013December 8, 2022ERROR 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