Advertisement
Guest User

Untitled

a guest
Jul 28th, 2015
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. # update values
  2. UPDATE myschema.example_table
  3. SET col1 = val1, col2 = val2, col3 = val3, col4 = val4
  4. WHERE col0 = primary_key
  5. LIMIT 5
  6. ;
  7.  
  8. # delete rows
  9. DELETE FROM myschema.example_table
  10. WHERE col1 = val1
  11. LIMIT 1
  12. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement