Editing ray

Title / Description

Code
/* Add $.08 to all USPS Domestic First-Class Rates */ UPDATE `weight_zone_service_domestic` SET shipping_cost = (shipping_cost + .08) WHERE `service` LIKE '1' AND service_name LIKE '%First-Class%'; /* Raise minimum to $2.75 for all USPS Domestic First-Class Rates */ UPDATE `weight_zone_service_domestic` SET shipping_cost = 2.75 WHERE shipping_cost < 2.75 AND `service` LIKE '1' AND service_name LIKE '%First-Class%'; /* Add $.20 to all USPS Domestic Priority Mail Rates */ UPDATE `weight_zone_service_domestic` SET shipping_cost = (shipping_cost + .20) WHERE `service` LIKE '1' AND service_name LIKE '%Priority%'; /* Add $.45 to all USPS International (Non-Canada) First-Class Mail Rates */ UPDATE `weight_service_international` SET shipping_cost = (shipping_cost + .45) WHERE `service` = '1' AND service_name LIKE '%First-Class%' AND excluding_canada = '1'; /* Add $6.39 to all USPS International (Non-Canada) Priority Mail Rates */ UPDATE `weight_service_international` SET shipping_cost = (shipping_cost + 6.39) WHERE `service` = '1' AND service_name LIKE '%Priority%' AND excluding_canada = '1'; /* Add $3.00 to all USPS International (Canada) Priority Mail Rates */ UPDATE `weight_service_international` SET shipping_cost = (shipping_cost + 3.00) WHERE `service` = '1' AND service_name LIKE '%Priority%' AND excluding_canada = '0'; /* Add $.37 to all USPS International (Canada) First-Class Mail Rates */ UPDATE `weight_service_international` SET shipping_cost = (shipping_cost + .37) WHERE service = '1' AND service_name LIKE '%USPS First-Class%' AND excluding_canada = '0'

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code