如何在 phpMyAdmin 中显示“编辑"、“复制"和“删除"按钮?

本文介绍了如何在 phpMyAdmin 中显示“编辑"、“复制"和“删除"按钮?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我是后端开发的新手，现在我正在尝试学习 SQL，我有 2 个表、1 个用户表和 1 个 post 表.在下面的用户表中，有编辑"、复制"和删除"按钮可用

I am new in backend development, and now i am trying to learn about SQL, i have 2 tables, 1 users table and 1 post table. in users table as we can see below, there are 'edit','copy' and 'delete' buttons available

但在我的帖子表中，那些编辑"、复制"和删除"按钮不可用

but at my post table, those 'edit','copy' and 'delete' buttons are not available

我知道我也可以使用 SQL 语句删除它，但有时如果我只是从 GUI 中删除它会更容易.

I know that I also can delete it using SQL statement, but sometimes it will be easier if i just do it from GUI.

DELETE FROM post WHERE id = '52'

我在创建表格时出错了吗?如何显示这些按钮?

do i make a mistake while creating a table ? how to show up those buttons?

提前致谢:)

推荐答案

那是因为你没有主键:

我是在 demo.phpmyadmin 上做的:

I did it on the demo.phpmyadmin :

无主键

带主键