mysql的distinct数据插入 - - vulsee.com

mysql想把乌云漏洞库的漏洞类型单独入表，无奈怎么都语法错误，如：

insert into  table (types) values( select distinct(type) from bugs)

insert into table (select distinct(type) from bugs)

最后尝试：

insert into types_copy (types_copy.bugtype) (SELECT DISTINCT(bugs.wybug_type) FROM bugs)

OK