毎回忘れるのでメモ
以下の書き方はNG(毎回やらかす)
insert into table_name (col1, col2, ...)
values (select col1, col2, ... from table2_name);
正解はこちら
insert into table_name (col1, col2, ...)
select col1, col2, ... from table2_name;
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme