mysqlでselectの結果を一括してinsertしたい場合
下記でusersのデータ分すべてuser_infosにinsertが可能
insert ignore into user_infos ( id, user_id, name, deleted, created, modified ) select NULL, id, NULL, deleted, NOW(), NOW() from users order by id asc;
下記でusersのデータ分すべてuser_infosにinsertが可能
insert ignore into user_infos ( id, user_id, name, deleted, created, modified ) select NULL, id, NULL, deleted, NOW(), NOW() from users order by id asc;