Insert as new row & auto_increment
58 views
Skip to first unread message
Paul
Mar 29, 2011, 12:32:13 PM3/29/11
to SQL Buddy
Hi,
Maybe I am missing something here but it seems strange that when I
choose to edit a row, then modify it to create a new row and choose
"Insert as new row", the auto_increment key is not invoked so I get a
duplicate entry for the key value. Could the new row not have it's key
auto_incremented?
Maybe I am missing something here but it seems strange that when I
choose to edit a row, then modify it to create a new row and choose
"Insert as new row", the auto_increment key is not invoked so I get a
duplicate entry for the key value. Could the new row not have it's key
auto_incremented?
Calvin Lough
Mar 29, 2011, 12:35:13 PM3/29/11
to sql-...@googlegroups.com
A new key will be generated for the row if you erase the text box containing the old key. Otherwise, the old key will be used for the new row.
Calvin
Paul
Mar 30, 2011, 5:20:37 AM3/30/11
to SQL Buddy
D'oh! That's so obvious... Thanks Calvin!
Reply all
Reply to author
Forward
0 new messages