How to solve the database error report ERROR 1786 (HY000)

This article mainly introduces "how to solve database error reporting ERROR 1786 (HY000)". In daily operation, I believe many people have doubts about how to solve the problem of database error reporting ERROR 1786 (HY000). The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "how to solve database error reporting ERROR 1786 (HY000)". Next, please follow the editor to study!

After executing the following statement:

Create table gltable select * from mysql.user

The error is as follows:

ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE. SELECT

This is because MySQL GTID has some scenario restrictions, the solution of create statement restrictions in GTID.

Use like, which is specific to MySQL, such as:

Create table gltable like mysql.user; here, on "how to solve the database error ERROR 1786 (HY000)" on the end of the study, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!