Advertisement
Guest User

Untitled

a guest
Sep 3rd, 2014
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. +--------+-----------+
  2. | num | text |
  3. +--------+-----------+
  4. | 1 | one |
  5. | 2 | two |
  6. | 3 | dont |
  7. | 4 | four |
  8. | 5 | five |
  9. +--------+-----------+
  10.  
  11. update Table_A set `text`='three' Limit 2,1
  12. update Table_A set `text`='three' where 1 Limit 2,1
  13.  
  14. UPDATE `Table_A` SET `text` = 'three' WHERE `num` = 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement