Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +--------+-----------+
- | num | text |
- +--------+-----------+
- | 1 | one |
- | 2 | two |
- | 3 | dont |
- | 4 | four |
- | 5 | five |
- +--------+-----------+
- update Table_A set `text`='three' Limit 2,1
- update Table_A set `text`='three' where 1 Limit 2,1
- UPDATE `Table_A` SET `text` = 'three' WHERE `num` = 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement