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.
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
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.