mysql将select結果儲存至另一個表

1 新表不存在

create table zpjbxx select * from jbxx where AJLB = ‘類别’;

2 新表已定義

create table zpjbxx(ID INT AUTO_INCREMENT PRIMARY KEY, AJLBBH varchar(20), AJLB varchar(100), AJXXLB varchar(100), AJMC TEXT, JYAQ TEXT);

insert into zpjbxx(AJLBBH,AJLB,AJXXLB,AJMC,JYAQ) select AJLBBH,AJLB,AJXXLB,AJMC,JYAQ from jbxx where AJLB = ‘類别’';