Advertisement
Guest User

Untitled

a guest
Oct 20th, 2014
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. ALTER TABLE `foo`
  2. ADD COLUMN `is_updated` tinyint(1) NOT NULL DEFAULT 0; //0 = not updated. 1 = updated
  3.  
  4. SELECT * FROM `foo` WHERE `is_updated` = 0 ORDER BY `id` ASC LIMIT 1000
  5.  
  6. UPDATE `foo` SET `is_updated` = 1 ORDER BY `id` ASC LIMIT 1000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement