Delete, edit, copy option

Asked

Viewed 7,452 times

-2

I want to delete an item in the phpmyadmin table but it does not appear, How do I show these options? I will leave a print below:

inserir a descrição da imagem aqui

phpmyadmin

  • What version of phpMyAdmin are you using? post a full print of phpmyadmin tbm, not just a part. Also try another browser to see the result.

  • The Version is 4.1.8 more on other Tables appears smoothly.

  • appears this message Current Selection does not contain a Unique column. Grid Edit, checkbox, Edit, Copy and Delete Features are not available.

  • 2

    From what I’m seeing in the print, all products have ID = 1 so phpmyadmin can’t select a Row, since it wouldn’t have what to select. try to click on the SQL tab and make a SELECT item,howmany,price FROM \table` WHERE item="banana"` and phpmyadmin should "work" but this problem ta in your table, makes a ALTER to leave the ID field as PQ (Primary Key) in the structure tab

  • https://answall.com/questions/128025/como-setar-uma-primary-key-a-uma-tabela-j%C3%A1-existing-no-oracle

3 answers

2

Probably the user account you are using to access the database is not allowed to edit, create or delete.

In cPanel, go to "Mysql Database" and associate a new account to the database but this time assign all privileges to the relation.

inserir a descrição da imagem aqui

1

Phpmyadmin is telling you that there is no primary key in this table. It has no way to identify which fields to use for UPDATE, DELETE, etc.
Try to define the table primary key and see if you can.

1

mysql needs a primary key, but currently speaking, try adding an id field in the table and mark the AI(Auto increment) so it will populate the fields with ids and will enable the fields for editing( make updates, Inserts... etc)

Browser other questions tagged phpmyadmin

You are not signed in. Login or sign up in order to post.