MySQL table edit via Navicat

Posted on 2012-08-20
Last Modified: 2012-08-20
I use Navicate to manage my MySQL tables. On one particular table I have run into the following issue.

if I edit the value the field 'employement' to abc and then press the check to accept or into another field and reload the value is changed.

However, if I set the value to abc, then go to another field 'salary' and make it 123 and return to the employment field and type def  and accept the new entry and then refresh the page or close he table and reopen it only the abc is saved.

I have tested this in a different table and it works fine.  It is just this one table giving me issues. I duplicated the table, but the issue continued.
Question by:lvmllc
    1 Comment

    Accepted Solution

    Figured out the issue  - there were mistakenly two fields set as keys.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi ( had suggested a “sed” way, I actually shell …
    Creating and Managing Databases with phpMyAdmin in cPanel.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 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

    10 Experts available now in Live!

    Get 1:1 Help Now