Mysql去除重复值列，只保留一条_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB原創
- 2016-06-01 13:32:041052瀏覽
bitsCN.com
Mysql去除重复值列，只保留一条
1DELETE2FROM3 software USING (software,(SELECT DISTINCT min(id) AS id, ident FROM software GROUP BY ident HAVING count(1) > 1) AS t2)4WHERE5 software.ident = t2.ident6AND software.id > t2.id;
bitsCN.com
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn