mysql语句异常
yw2567
无无无无无无
展开
-
ajax,jquery,json
一种拼接的方法,在sql语句中拼接原本的where条件换为形式,添加if条件判断<mapper namespace="com.neuedu.ssm.dao.ItemDao"> <select id="getItem" parameterType="Item" resultType="Item"> select*from item <where>原创 2017-12-11 09:22:18 · 112 阅读 · 0 评论 -
Parameter index out of range (1 > number of parameters, which is 0)
是mysql对应的语句<update id="updateDelete" parameterType="map"> UPDATE wx_shop_db.mst_customer wmc LEFT JOIN promotion_db.mst_coupon pmc ON wmc.customer_cd=pmc.custom原创 2017-12-06 11:04:49 · 123 阅读 · 0 评论 -
Parameter index out of range (1 > number of parameters, which is 0).
<update id="updateDelete" parameterType="map"> UPDATE wx_shop_db.mst_customer wmc LEFT JOIN promotion_db.mst_coupon pmc ON wmc.customer_cd = pmc.customer_cd原创 2017-12-06 14:32:59 · 278 阅读 · 0 评论 -
[Err] 1062 - Duplicate entry '' for key 'PRIMARY'
我在写insert的时候刚开始没加主键的属性coupon_card_cd, 加入后正常运行 <insert id="insertDelete_Log_Coupon" parameterType="map"> INSERT INTO promotion_db.mst_log_coupon (coupon_card_cd,原创 2017-12-07 10:56:08 · 4991 阅读 · 0 评论 -
[Err] 1054 - Unknown column 'pmc.del_coupon_card_cd' in 'field list'
这个异常在我这里是pmc.del_coupon_card_cd在查询表没有,在添加log表里有,删除后改变赋值方式为${del_coupon_card_cd}用controller传值过来即可原创 2017-12-07 11:25:21 · 238 阅读 · 0 评论