如何在 phpMyAdmin 中显示“编辑"、“复制"和“删除"按钮? [英] How to show up 'edit','copy' and 'delete' buttons in 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.com 上做的:

I did it on the demo.phpmyadmin.com :

无主键

带主键

这篇关于如何在 phpMyAdmin 中显示“编辑"、“复制"和“删除"按钮?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！