I would love to have an option to do a Batch Update. This is different than the Batch Upsert. In general I do not like the batch upsert as if there is an error in the UI to submit something it will rather than update a field, it will create a new field. I prefer to yell back tot he UI that something was not found. The createInBatches for creates is amazing and definately my favorite feature of GORM 2.0. I have refactored my code so I don't have to do this through SQL, I just need a batch update equivalent.
Comment From: github-actions[bot]
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨
Comment From: VishwasShashidhar
+1
Comment From: github-actions[bot]
The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨
Comment From: github-actions[bot]
This issue has been automatically marked as stale because it has been open 360 days with no activity. Remove stale label or comment or this will be closed in 180 days
Comment From: jobsLee-lcj
+1，I need this too, pure batch update, not batch upsert.In mycase, the records should be updated frequently。Currently, I am using the OnConflict method as batch upsert. However, due to ON DUPLICATE KEY UPDATE, it leads to the consumption of auto-increment IDs, causing significant gaps in the auto-increment IDs of the table records.
