Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER TABLE `foo`
- ADD COLUMN `is_updated` tinyint(1) NOT NULL DEFAULT 0; //0 = not updated. 1 = updated
- SELECT * FROM `foo` WHERE `is_updated` = 0 ORDER BY `id` ASC LIMIT 1000
- UPDATE `foo` SET `is_updated` = 1 ORDER BY `id` ASC LIMIT 1000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement