用sql语句向表中的一列插入多条数据

Question

请教高手，谢谢

Answer 1

insert into table_name (col1)
select 'a' union
select 'b' union
select 'c'

insert into table_namea(col1)
select col2 from tableb本回答被提问者采纳