帮我看下下面这段sql在pg库执行哪里有语法错误:insert into pac_eda.tb_kddddrpt_pac_zqping_perception_day select vareaid ,vareaname ,vcjpingcnt ,vcjpingsuccnt ,vcjsendbagsum ,vcjreceivedbagsum ,vcjreceivedbagrate ,vcjlostsixthcnt ,vcjlostcnt ,vcjlongtimeoverwarmcnt ,vmarkippingcnt ,vmarkippingsuccnt ,vmarkiplostsixthcnt ,vmarkiplostcnt ,vmarkiplongtimeoverwarmcnt ,vremark1 ,vremark2 ,vremark3 ,vremark4 ,vremark5 ,vremark6 ,vremark7 ,vremark8 ,vremark9 ,vremark10 ,vtotalrank1 ,vtotalcnt ,'20230714' vbegday from tb_kddddrpt_pac_zqping_perception_day where vbegday='20230713'
时间: 2023-10-09 08:13:45 浏览: 67
在这段SQL中,语法错误出现在最后一行。在`from tb_kddddrpt_pac_zqping_perception_day where vbegday='20230713'`这一行,你使用了全角空格(Unicode字符U+3000),而不是标准的半角空格。请将全角空格替换为半角空格,即`from tb_kddddrpt_pac_zqping_perception_day where vbegday='20230713'`。这样就可以解决语法错误了。
阅读全文