This came up to me when trying to copy paste row with auto increment primary key id-field. Heidi-SQL has duplicate field which gives next free value to auto increment primary key. This is very useful feature. (i did not find to way to use auto increment when using paste as new record)

I noticed that we can now copy/paste an entire row in the editable table
view, which is great! However, it's a bit annoying that the row id
uniqueness check constantly pops up an alert, to tell us that the Id column
is not unique. Yes we know, and we're trying to fix it. This check makes
sense when cached updates mode is off, but not when it's on. The only
workaround is to give it a temporary dummy id, while I go and generate a
new one (we're using GUIDs). I think that the check should be performed
only when applying the changes.