Guest User

Untitled

a guest
Jul 16th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS test (textt text, ip varchar(22), uid varchar(128));
  2. CREATE UNIQUE INDEX ON test (uid);
  3.  
  4. var db_uid string
  5. err = db.QueryRows("INSERT INTO test (textt, ip, uid) VALUES ($1, $2, $3) ON CONFLICT (uid) DO NOTHING", "hello", "192.168.0.1", curr_uid).Scan(&db_uid)
  6. sreq, err := db.Exec("UPDATE test SET uid = ($1), ip = ($2), textt = ($3) WHERE uid = ($4)", curr_uid, "192.168.1.1", "goodbye", db_uid)
  7.  
  8. INSERT INTO test (textt, ip, uid) VALUES ($1, $2, $3) RETURNING (uid) ON CONFLICT (uid) DO NOTHING;
Add Comment
Please, Sign In to add comment