同じ定義のテーブルを作成し、全データをインサートする。
auto_increment の値まではコピーできないので注意。
table_copy.sql
create table copied_table like origin_table;
insert copied_table select * from origin_table;
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
List of users who liked
33