数据插入报错

### The error may exist in file [/Users/xiao_xiaoxiao/Desktop/javaweb/o2o2/target/classes/mapper/ProductSellDailyDao.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: insert into tb_product_sell_daily(product_id,shop_id,create_time,total) ( select product_id,shop_id,date_format(create_time,'%Y-%m-%d'),0 as total from tb_product p where p.product_id not in ( select product_id from tb_product_sell_daily where date_format(create_time,'%Y-%m-%d')=date_sub(curdate(),interval 1 day) GROUP by product_id )

### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 11

肖小小 2019-09-30

源自：项目：校园商铺——框架大换血 4-9 Echarts的动态化改写上

收起

2回答

好帮手慕柯南回答被采纳获得+3积分 2019-09-30 13:25:10

同学这里是不是少写了表的别名，并且后面多写了group by呢

同学可以参考一下老师的sql：

<insert id="insertDefaultProductSellDaily">
   INSERT
   INTO
   tb_product_sell_daily(product_id,shop_id,create_time,total)
   (
   SELECT
   p.product_id,p.shop_id,date_sub(curdate(),interval 1 day),0 AS
   total
   FROM
   tb_product p
   WHERE
   p.product_id not in (select product_id from
   tb_product_sell_daily where date_format(create_time,'%Y-%m-%d') =
   date_sub(curdate(),interval 1 day))
   )
</insert>

如果我的回答解决了你的疑惑，请采纳，祝学习愉快~

收起回答

肖小小提问者 #1

<insert id="insertDefaultProductSellDaily" > insert into tb_product_sell_daily(product_id,shop_id,create_time,total) ( select p.product_id,p.shop_id,date_sub(curdate(),interval 1 day),0 as total from tb_product p where p.product_id not in ( select tb.product_id from tb_product_sell_daily tb where date_format(tb.create_time,'%Y-%m-%d')=date_sub(curdate(),interval 1 day) ) </insert> ### SQL: insert into tb_product_sell_daily(product_id,shop_id,create_time,total) ( select p.product_id,p.shop_id,date_sub(curdate(),interval 1 day),0 as total from tb_product p where p.product_id not in ( select tb.product_id from tb_product_sell_daily tb where date_format(tb.create_time,'%Y-%m-%d')=date_sub(curdate(),interval 1 day) ) ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10 还是一样

2019-10-01 15:50:05