Guest User

Untitled

a guest
Sep 30th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. INSERT INTO `table` (`id`, `name`, `email`)
  2. VALUES
  3. ('1-', 'oleg', 'qqq@mail.ru'),
  4. ('2-', 'dima', 'ggg@mail.ru'),
  5. ('3-', 'petr', 'mmm@mail.ru'),
  6. ('4-', 'anna', 'nnn@mail.ru')
  7. и так далее...
  8. ON DUPLICATE KEY UPDATE `name` = ????? `email` = ??????
  9.  
  10. <?
  11. // $arr - массив данных (порядка 10к строк формата: "('1-', 'oleg', 'qqq@mail.ru')")
  12. $mysqli->query("
  13. INSERT INTO `table` (`id`, `name`, `email`)
  14. VALUES ".implode(",", $arr)."
  15. ON DUPLICATE KEY UPDATE `name` = ????? `email` = ??????
  16. ")
  17. ?>
Add Comment
Please, Sign In to add comment