• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 95
  • Last Modified:

PhpMyAdmin, mysql database table editing

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.
0
Braveheartli
Asked:
Braveheartli
  • 2
1 Solution
 
Julian HansenCommented:
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 ?
0
 
Ferruccio AccalaiSenior 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
0
 
BraveheartliMarketingAuthor 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,
0
 
BraveheartliMarketingAuthor Commented:
thank you
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now