MySQL添加多个字段
alter table shop_device_day add
(
bns_area1_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown',
bns_area2_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown',
bns_area3_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown',
bns_area4_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown',
bns_area5_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown',
bns_area6_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'unknown'
);