Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `table` (`id`, `name`, `email`)
- VALUES
- ('1-', 'oleg', 'qqq@mail.ru'),
- ('2-', 'dima', 'ggg@mail.ru'),
- ('3-', 'petr', 'mmm@mail.ru'),
- ('4-', 'anna', 'nnn@mail.ru')
- и так далее...
- ON DUPLICATE KEY UPDATE `name` = ????? `email` = ??????
- <?
- // $arr - массив данных (порядка 10к строк формата: "('1-', 'oleg', 'qqq@mail.ru')")
- $mysqli->query("
- INSERT INTO `table` (`id`, `name`, `email`)
- VALUES ".implode(",", $arr)."
- ON DUPLICATE KEY UPDATE `name` = ????? `email` = ??????
- ")
- ?>
Add Comment
Please, Sign In to add comment