SELECT
app_name AS appName,
app_id As appId,
DATE_FORMAT(create_time, '%Y') AS date
FROM
aisv_g_app_info
WHERE
DATE_FORMAT(create_time, '%Y') = #{year}
AND is_del = 0
AND app_state = 5
AND developer_id = #{developerId}




SELECT
app_name AS appName,
app_id As appId,
DATE_FORMAT(create_time, '%Y-%m') AS date
FROM
aisv_g_app_info
WHERE
DATE_FORMAT(create_time, '%Y-%m') = #{month}
AND is_del = 0
AND app_state = 5
AND developer_id = #{developerId}




SELECT
app_name AS appName,
app_id As appId,
DATE_FORMAT(create_time, '%Y-%m-%d') AS date
FROM
aisv_g_app_info
WHERE
DATE_FORMAT(create_time,'%Y-%m-%d') #{todayStr} AND
DATE_FORMAT(create_time,'%Y-%m-%d')= ]]>#{sevenDayBeforeStr}
AND is_del = 0
AND app_state = 5
AND developer_id = #{developerId}

SELECT *
FROM
aisv_g_user_operation_log

1=1

and
user_name =#{param.userName}


and
USER_IP =#{param.userIp }


and
OPERATION_TYPE =#{param.operationType}


and
OPERATION_TIME >=#{param.startdate}


and
OPERATION_TIME <=#{param.enddate}


order by OPERATION_TIME DESC
limit #{page.begin},#{page.pageSize}

@DateTimeFormat(pattern = "yyyy-MM-dd")
@JsonFormat(pattern = "yyyy-MM-dd")
private LocalDateTime transactionDate;

MySQL中大于等于小于等于的写法

由于在mybatis框架的xml中<= , >=解析会出现问题,编译报错,所以需要转译
第一种写法：

原符号 < <= > >= & ’ "
替换符号 < <= > >= & ' "
例如：sql如下：

unix_timestamp(target.mc_end_date)<= unix_timestamp(#{MonthEndTime})；unix_timestamp(target.mc_start_date) >= unix_timestamp(#{MonthBeginTime})

• 1

第二种写法：
大于等于

小于等于

例如：sql如下：

mc_end_date = ]]> #{endTime} and  mc_start_date  #{startTime}