locid country city
39409 US Aaronsburg
128426 US Aaronsburg
340356 US Aaronsburg
429373 US Aaronsburg
422717 US Abbeville
431344 US Abbeville
433062 US Abbeville
341726 US Abbeville
421248 US Abbeville
40779 US Abbeville
326718 US Abbeville
317654 US Abbeville
16707 US Abbeville
25771 US Abbeville
120301 US Abbeville
132115 US Abbeville
121770 US Abbeville
130397 US Abbeville
5585 US Abbeville
10227 US Abbeville
190173 US Abbeville
491120 US Abbeville
311174 US Abbeville
306532 US Abbeville
164271 US Abbot
465218 US Abbot
58452 US Abbotsford
359399 US Abbotsford
309116 US Abbotsford
8169 US Abbotsford
can someone give me an sql query to help me clean up this table?
after clean up locid(the index) should be resetted, btw this is a county city using this query SELECT locid, country, city FROM location WHERE country = 'US' ORDER BY city ASC
. this redundant data came about when i imported an sql text many times through phpmyadmin's import and this is the result,