Troubleshooting of mysqlerrornumber1051 and 1418 errors

Mysqlerrornumber1051 said a lot on the Internet (including foreign networks), but no one knows why. This is caused by different storeengine

Mysql error number 1051 says a lot on the Internet (including foreign networks), but no one knows why. This is caused by different store engines.

Mysql error number 1051 says a lot on the Internet (including foreign networks), but no one knows why. This is caused by different store engines.

For example, if the first engine = myisam and table A are created on this basis, you need to convert it to innodb now (enable my. the innodb parameter in cnf) if you select table A again, it will report non-existent data. If you drop the data, mysql error number 1051 will be reported. how can this problem be solved? Haha, turn off my first. the innodb parameter of cnf, and then restart mysql, so that A can select, back up table A, drop Table A, enable the innodb parameter, and restart mysql, restore the backup script.

If there is a 1418 error in the create function:

Set global log_bin_trust_routine_creators = 1;

Then there will be no problem with how to create a function (of course, your function must be correct). Damn it, this is a mysql bug. If you don't understand why, it will be okay to do so anyway.

There is no such error in Oracle. If such an error occurs, it is because of insufficient user permissions. OpenSource is like this. It is better for Oracle.

,