Can not delete data from phpMyAdmin? [duplicate]

Question

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.

Answer 1

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.