Solved

PhpMyAdmin, mysql database table editing

Posted on 2016-09-23
4
73 Views
Last Modified: 2016-09-23
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
Comment
Question by:Braveheartli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41812241
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
 
LVL 22

Accepted Solution

by:
Ferruccio Accalai earned 500 total points
ID: 41812322
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
 
LVL 1

Author Comment

by:Braveheartli
ID: 41812339
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
 
LVL 1

Author Closing Comment

by:Braveheartli
ID: 41812347
thank you
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses four methods for overlaying images in a container on a web page
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question