MySQL Update
MySQL update
UPDATE LANGUAGE SET language_code = lower(language_code)
MySQL update from data
UPDATE translation_country tc1
LEFT JOIN translation_country tc2 ON tc1.country_id = tc2.country_id
SET tc1.tcountry_order = tc2.tcountry_order
WHERE tc1.language_id = 10 AND tc2.language_id = 1
LEFT JOIN translation_country tc2 ON tc1.country_id = tc2.country_id
SET tc1.tcountry_order = tc2.tcountry_order
WHERE tc1.language_id = 10 AND tc2.language_id = 1
REFERRERS
MySqlDataManipulation
There are no comments on this page. [Add comment]