Navicat query results can not be modified by the reasons and solutions _mysql

Problem:

In development, you often use Navicat to query the database and modify the values in the database. Today found that the query result is read-only and cannot be modified. General can not change the table to amend I know, but the single table can not be modified.

Workaround:

Checked, there is said that the table is read-only, but also said that the authority is not enough. It was later found not because the table did not have a primary key set.

The above Navicat query results can not be modified by the reasons and solutions are small series to share all the content, hope to give you a reference, but also hope that we support the cloud habitat community.