摘要：SELECT declare_type_id,support_model,project_name,CONCAT(declare_type_id,support_model,project_name) from gf_index；
阅读全文
posted @ 2020-01-11 22:48
01 2020 档案
摘要：日期取年、月、日 select id, phone,time,year(time),month(time), DAY(time),TIME(time) from user where phone='xx' #分别取年、月、日、时间select id, phone,time,year(time) fr
阅读全文
posted @ 2020-01-11 21:31
摘要：select `a`.`tdorderid`,group_concat('类型：',(case `a`.`td_type` when 'no_goods' then '无货退款' when 'low_quantity' then '质量退款' when 'no_reason' then '非质量退款
阅读全文
posted @ 2020-01-09 15:53
