PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Tuesday, October 11, 2022

[FIXED] How to show up 'edit','copy' and 'delete' buttons in phpMyAdmin?

 October 11, 2022     phpmyadmin     No comments   

Issue

I am new in back-end 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

enter image description here

But at my post table, those 'edit','copy' and 'delete' buttons are not available enter image description here

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?


Solution

It's because you don't have a primary key:

I did it on the demo.phpmyadmin.com :

No primary key

No primary key

With primary key

With primary key



Answered By - Daniel E.
Answer Checked By - Pedro (PHPFixing Volunteer)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing