CREATE TABLE new_table AS SELECT * FROM old_table;
SELECT COUNT(*) FROM テーブル名
..:::insert文:::..
┌—————————————-┐
│id │int │ auto_increment │
│CAL01 │varchar(10) │ │
│CAL02 │varchar(20) │ │
└—————————————-┘
insert into TABLE values(NULL’data01′,’data2′);
..:::alter文:::..
alter table TABLE add CAL03 varchar(9) after CAL01;
..::inport::…
load data local infile “dump.csv” into table TABLE fields terminated by ‘,’;