Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update a column of the first 5000 rows of a table in MYSQL version 5.1.11
- update clientdetails set lastupdateddate=now where id in (Select id from clientdetails limit 1,5000);
- update clientdetails set lastupdateddate=now where <your where clause>
- limit <desired limit>;
- SELECT * FROM table1 WHERE foo IN (SELECT foo FROM table2 LIMIT 50)
- SELECT *
- FROM table1 t
- JOIN (SELECT foo FROM table2 LIMIT 50) as tmp
- ON tmp.foo = t.foo;
- UPDATE clientdetails
- SET lastupdateddate = NOW()
- ORDER BY id
- LIMIT 0, 5000;
Add Comment
Please, Sign In to add comment