Set auto_increment column to 0 when selecting any of the insert options in the submit_type dropdown.
Solution for feature req ID: 3480477
Thanks for your patch.
It works well when editing; however, when inserting, there is one unpleasant effect: I enter a primary key value, then change the selector to "insert as new row and ignore errors" and I lose the value I typed.
Updated patch including fix for problem described by lem9
Added new patch, the one names 0002(!) is the latest one, try that instead.
Merged, thanks. See my commit 7b5c5f902eb1f0f0a17d5193459727c1abb7fa77 for minor code cleanup.
Also, it does not work in the "with selected... change" dialog so it could be improved.
Fixed with selected problem
See latest patch, with_selected_auto_increment_auto_0_20120204_v2.patch which makes it work with the "with-selected...change"-dialog. A bit better and cleaner code as well.
with latest patch applied on current master, I have this problem
1. browse a table
2. click on edit for a row
3. choose "insert as new row": the PK is not set to 0