統計重復數據：

SELECT COUNT(*) as repeat_count, t.txt
FROM
    index_shenhf_copy t
GROUP BY
    t.txt
HAVING
    repeat_count > 1;

過濾重復數據方式1：

SELECT
    DISTINCT t.txt
FROM
    index_shenhf_copy t;

過濾重復數據方式2

SELECT
    t.txt,t.id
FROM
    index_shenhf_copy t
GROUP BY
    t.txt,t.id;

過濾創建新表

CREATE TABLE tmp SELECT
    t.txt,t.time
FROM
    index_shenhf_copy t
GROUP BY
    t.txt;