Advertisement
Guest User

Untitled

a guest
Apr 1st, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 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')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement