Edits not saving in Grid View

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
kpl
Posts: 3
Joined: Thu 10 Aug 2017 18:48

Edits not saving in Grid View

Post by kpl » Thu 10 Aug 2017 19:14

I have a table in grid view that has some duplicate rows. I have gone into the table and changed one of the rows to what I want it to be, but when I Select File Save All, Exit out of the Table, Then Open it Again, the data is unchanged. What mistake am I making.

Original View of duplicate rows:

antiCCP
antiCCP

My edits:

antiCCP
anti-CCP

After Saveall, quit, getting back into table
anti-CCP
anti-CCP

Could you tell me what I am doing wrong? I don't have any unique or primary keys set in this table.

Thanks.

YuriP
Posts: 15
Joined: Fri 27 May 2016 12:49
Location: Devart
Contact:

Re: Edits not saving in Grid View

Post by YuriP » Fri 11 Aug 2017 12:40

Hello,

We use the UPDATE command to edit a table record. For the correct work of this command, you need a unique WHERE condition. If you don't have any unique key for this recordset the UPDATE command works without the unique WHERE condition, and your changes will apply for all records in the recordset.

Best regards,
Yuri.

Post Reply