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

Tuesday, January 25, 2022

[FIXED] Can not delete data from phpMyAdmin?

 January 25, 2022     mysql, phpmyadmin     No comments   

Issue

I create a table in database and enter some data into table.But i want to delete data from table manually but there are no option on phpMyAdmin. Here is a picture.


Solution

You need creating a primary key in phpMyAdmin to be able to delete rows.

If there isn't a field that can be used as a primary key, you can add an 'id' column with autoincrement, or you can use multiple columns primary key. You can go to Structure menu to add the key. After defining primary key, phpMyAdmin can manage deletion, but this is a phpMyAdmin issue, not a MySQL one. In fact you could delete a row by ad hoc sql query.



Answered By - IgrewupwithSlackware
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home
View mobile version

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