Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `table` (`id`, `name`, `email`)
- VALUES
- ('1-', 'oleg', '[email protected]'),
- ('2-', 'dima', '[email protected]'),
- ('3-', 'petr', '[email protected]'),
- ('4-', 'anna', '[email protected]')
- и так далее...
- ON DUPLICATE KEY UPDATE `name` = ????? `email` = ??????
- <?
- // $arr - массив данных (порядка 10к строк формата: "('1-', 'oleg', '[email protected]')")
- $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