Mysql-error 1235 (42000)

1.1.1 Phenomenon

When exporting a MySQL database to a file, the following error occurs when importing:

ERROR 1235 (42000) at line 267:this version of MySQL doesn ' t yet support ' multiple triggers with the same action time and Event for one table '

1.1.2 Reasons

The exported content contains triggers, so this error occurs when importing.

1.1.3 Solution

When exporting, add the--triggers=false parameter, turn off the trigger, but this will cause the trigger to not be exported, but also to find another way to guide the trigger, command example:

Mysqldump-u ROOT-P1--triggers=false I2goods>d:\i2.sql

Mysql-error 1235 (42000)