dd_Gao的博客

UPDATE tableName SET orderId1 = CASE id WHEN 1 THEN 3 WHEN 2 THEN 4 WHEN 3 THEN 5 END, orderId2 = CASE id WHEN 1 THEN 3 WHEN 2 THEN 4 WHEN 3 THEN 5.

-- 天数转日期 UPDATE table_a SET report_date = DATE_FORMAT(FROM_DAYS(( report_date-2) + TO_DAYS('1900-01-01')) ,'%Y%m%d') WHERE LENGTH( report_date ) = 5 ; -- CST (格林威尔时间转) yyyymmdd UPDATE table_a SET join_net_date = REPLACE(STR_TO_DATE(REPLACE(join_net_dat..