Solved

PhpMyAdmin, mysql database table editing

Posted on 2016-09-23
4
44 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
  • 2
4 Comments
 
LVL 51

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Creating and Managing Databases with phpMyAdmin in cPanel.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now