PhpMyAdmin, mysql database table editing

BR
BR used Ask the Experts™
on
when use PhpMyAdmin, I can easily see what content my tables have.
When I use PhpMyAdmin, I double click the table's row, I can edit the table data easliy.
But when I import a table to mysql database, I can not edit the data with double clicking it, do you know why? I can only edit the content with writing a sql statement.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Are you saying that when you import a table you are no longer to edit it with PHPMyAdmin?

What is the name of the table you are importing.

How are you importing the table ?
Senior developer, analyst and customer assistance
Commented:
Check if the imported table has a Primary Key or at least a UNIQUE index. If no key or index is defined PhpMyAdmin won't let you edit it to prevent any row's editing error, as you could choose a wrong (not indexed) row
BRDigital Marketing

Author

Commented:
my table name is haziran
there is nothing wrong with the name, I had an experience with bad names like COJ-Kit

I save as excel table as OpenDocument Spreadsheets then upload it to mysql database,
BRDigital Marketing

Author

Commented:
thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial