百度一下insert sql
select * from
(
select * from biaoming
union all
select '忠福点' as dianqu,
'202001' as riqi,
'asdas'as yuemubiao,
'232'as tianshu,
'asdasd' as id
)t
where riqi=''
你的问题 -几年- 是 -几列- 吧?
添加列:alter table 表名 add column 列名 varchar(30); 删除列:alter table 表名 drop column 列名;