update `table` set `date`=CONCAT(SUBSTR(`date`,7,4), SUBSTR(`date`,4,2), SUBSTR(`date`,1,2));