sql 语句把一个a表的数据插入到b表里

insert into a(bankId,bank_name,bank_code,image_url,client_id) select bankId ,bank_name,bank_code,image_url,client_id from b