Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 26th, 2012  |  syntax: None  |  size: 0.24 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. MySQL row locking myisam innodb
  2. select from tblA limit 50
  3.  and doing some kind of row locking for each row (which requires innodb)
  4.        
  5. UPDATE tblA SET status=1234567890 WHERE status IS NULL LIMIT 50;
  6. SELECT * FROM tblA WHERE status=1234567890;
create a new version of this paste RAW Paste Data