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

MySQL table edit via Navicat

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.
1 Solution
lvmllcAuthor Commented:
Figured out the issue  - there were mistakenly two fields set as keys.

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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