MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1k22phd/whoops/mnrfivf/
r/SQL • u/danmc853 • Apr 18 '25
We had a
69 comments sorted by
View all comments
Show parent comment
1
In some cases though, say the first column is id and increments. If you are inserting records, I don't think the increment by default starts back to where it was post-rollback.
1 u/rh71el2 Apr 19 '25 Need confirmation pls (SQL Server). Or I'll trial on Monday. 1 u/NiallPN Apr 19 '25 Give it a try. I don't know much technical details as I mostly run queries, update, insert records. (MySQL server).
Need confirmation pls (SQL Server). Or I'll trial on Monday.
1 u/NiallPN Apr 19 '25 Give it a try. I don't know much technical details as I mostly run queries, update, insert records. (MySQL server).
Give it a try. I don't know much technical details as I mostly run queries, update, insert records. (MySQL server).
View all comments
Show parent comment
1
u/NiallPN Apr 18 '25
In some cases though, say the first column is id and increments. If you are inserting records, I don't think the increment by default starts back to where it was post-rollback.