qq_40105969的博客

SELECT a.name ,a.id,b.province FROM  (SELECT  NAME,id  FROM t_area WHERE  parent_id =0) aLEFT JOIN (SELECT DISTINCT province FROM t_carbon_area WHERE deleted = 0 UNIONSELECT DISTINCT province FROM t_c...

`delete from fd_shop_rank where \`year_month\` = '${ym1}'`

insert into table_name ( col1, col2, col3 ) values ( #{field1}, #{field2}, #{field3} ) on duplicate key update col1 = #{field1}, col2 = #{field2}, col3 = #{field3}

select @rownum:=@rownum+1 AS rownum,id,dates from `data`,(SELECT @rownum:=0) r ORDER BY dates;