Mysql: Remove Duplicate Values on Creating A New Table

I had a reference table for all of the World Countries that i wanted to extract Currency data from to another new table. I initially use this code which created a new table with 263 records. CREATE TABLE currencies SELECT tld, currency, currencycode FROM countries ; I quickly realized that for the purpose I was […]