Error Code: 1175. You are using safe update mode…

What are the eight life cycle hook functions of Vue>>>

1. This is because MySQL is running in safe updates mode, which will result in that the update or delete command cannot be executed under non primary key conditions, and the set SQL command can be executed_ SAFE_ UPDATES = 0; Modify the database schema

2. If you want to improve the database security level, you can restore the original settings and execute the command: set SQL_ SAFE_ UPDATES = 1;

After successful execution, take the delete command as an example, an error is reported in the case of non primary key, indicating that the security level is modified successfully

Similar Posts: