数据库
super_admin_123
这个作者很懒,什么都没留下…
展开
-
spring cloud + mybatis 批量更新踩坑
错误信息: 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 当然从错误中并不能看到错误是在哪里。 解决步骤: 第一步:先将要批量执行的sql在数据库层执行以下查看是否真...原创 2019-04-10 17:23:59 · 631 阅读 · 0 评论 -
Mysql执行分组查询语句报错[Err] 1055 - 'bs4Order.tb_buyer_ticket_price.id' isn't in GROUP BY
1.执行sql SELECT `id`, count(passenger_type) AS passenger_count FROM tb_buyer_ticket_price WHERE 1 = 1 AND ticket_order_no = '' GROUP BY passenger_type; 错误信息 [Err] 1055 - 'bs4...原创 2019-07-29 11:15:20 · 231 阅读 · 0 评论