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
本文标题: | mysql的distinct数据插入 – – vulsee.com |
本文链接: (转载请附上本文链接) | https://vulsee.com/archives/vulsee_2021/1210_15881.html |