Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. $stmt=$pdo->prepare('INSERT INTO t(c1,c2,c3) VALUES(?,?,?)');
  2. $stmt->execute([9876543210,9876543210,9876543210]);
  3.  
  4. $sql='INSERT INTO t(pk,c1,c2) VALUES(?,?,?), (?,?,?), (?,?,?)
  5. ON DUPLICATE KEY UPDATE c1=VALUES(c1),c2=VALUES(c2)';
  6. $stmt=$pdo->prepare($sql);
  7. $stmt->execute([1,111,111,2,222,222,3,333,333]);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement