Guest User

Untitled

a guest
Nov 10th, 2017
522
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. INSERT INTO tablename (id, username, password, level, email)
  2. VALUES (1, 'John', 'qwerty', 5, 'john@mail.com')
  3. ON CONFLICT (id) DO UPDATE SET
  4. id=EXCLUDED.id, username=EXCLUDED.username,
  5. password=EXCLUDED.password, level=EXCLUDED.level,email=EXCLUDED.email
  6.  
  7. INSERT OR REPLACE INTO tablename (id, user, password, level, email)
  8. VALUES (1, 'John', 'qwerty', 5, 'john@mail.com')
  9.  
  10. INSERT INTO users (id, level)
  11. VALUES (1, 0)
  12. ON CONFLICT (id) DO UPDATE
  13. SET level = users.level + 1;
Add Comment
Please, Sign In to add comment