Desirae has posted 3 posts at DZone. View Full User Profile
// Example: used to remove duplicate zip/postal codes from a table with 5 columns: id, zip, latitude, longitude, country
ALTER IGNORE TABLE zipcode_table ADD UNIQUE INDEX dupidx (zip, country);
ALTER TABLE zipcode_table DROP INDEX dupidx
DZone's 170th Refcard is an essential reference to Camel, an open-source, lightweight, integration library. This Refcard is authored by...