Skip to content

Instantly share code, notes, and snippets.

@fimars

fimars/gorm - findInBatches.sql

Created November 12, 2024 07:06
Show Gist options
  • Save fimars/8cb37279e2d73b4c35a60753c35ee62c to your computer and use it in GitHub Desktop.
Save fimars/8cb37279e2d73b4c35a60753c35ee62c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gorm - findInBatches.sql
SELECT * FROM `table` WHERE shop_name = 'shopname' AND `table`.`is_delete` = 0 ORDER BY `table`.`id` LIMIT 10
SELECT * FROM `table` WHERE shop_name = 'shopname' AND `table`.`id` > 11087349 AND `table`.`is_delete` = 0 ORDER BY `table`.`id` LIMIT 10
SELECT * FROM `table` WHERE shop_name = 'shopname' AND `table`.`id` > 11087359 AND `table`.`is_delete` = 0 ORDER BY `table`.`id` LIMIT 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment