此表不包含唯一列.网格编辑、复选框、编辑、复制和删除功能不可用 [英] This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available

问题描述

phpMyAdmin 中产生的错误是:

The error generated in phpMyAdmin is:

此表不包含唯一列.网格编辑、复选框、编辑、复制和删除功能不可用.

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

此错误消息是什么意思，我该如何解决?

What does this error message mean and how can I fix it?

推荐答案

我也遇到过这个问题.

原因是您的表没有主键字段.

我有一个简单的解决方案:将一个字段设置为主键，以适合您的业务逻辑的特定字段.

例如，我有数据库thesis_db 和字段thesis_id，我将按下按钮Primary(键图标)将thesis_id 设置为主键字段:

I have been faced with this problem.

The cause is your table doesn't have a primary key field.

And I have a simple solution: Set a field to primary key to specific field that suits your business logic.

For example, I have database thesis_db and field thesis_id, I will press button Primary (key icon) to set thesis_id to become primary key field:

这篇关于此表不包含唯一列.网格编辑、复选框、编辑、复制和删除功能不可用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！