insert into table_name (col1, col2, ...) select col1, col2, ... from table2_name; Register as a new user and use Qiita more conveniently You get articles that match your needsYou can efficiently read back useful informationYou can use dark themeWhat you can do with signing up