è¤æ°ã«ã©ã ã§ã¦ãã¼ã¯ãã¼ãä½ãããã¨ããéè¤ãããã¨ã¨ã©ã¼ã«ãªã mysql> ALTER TABLE hoge ADD UNIQUE (a,b,c); ERROR 1062 (23000): Duplicate entry 'aiueokakikukekoaaaaa' for key 2 IGNOREãã¤ããã¨ãéè¤ããã«ã©ã ã¯æåã®åã ãæ¡ç¨ããã¦æ£å¸¸çµäºãã mysql> ALTER IGNORE TABLE hoge ADD UNIQUE (a,b,c); Query OK, 225165 rows affected (52.52 sec) Records: 225165 Duplicates: 1385 Warnings: 0 ã²ã¨ã¤ã®ã«ã©ã ã«ã¦ãã¼ã¯ãã¼ãä½ãããã ããªããéè¤ã¬ã³ã¼ããåé¤ãã¦ãã¾ãã°å¤§ä½åé¡ãªã DELETE FROM hoge WHERE a in (SE
{{#tags}}- {{label}}
{{/tags}}