SQL 报错:INSERT INTO wg_purchase_V001 语句缺少逗号
这个 SQL 语句报错是因为在 SELECT 子句的最后一行缺少逗号。正确的语句应该是:\n\nINSERT INTO wg_purchase_V001 (\n PID,\n Pc_GXName,\n Pc_GXValue,\n Pc_Order,\n Pc_GXTotalValue,\n Pc_IsAuto,\n Pc_GxSort,\n Pc_GxPrice,\n Pc_GxNum,\n Pc_IsCheck,\n Pc_GXValue1,\n Pc_GXMan,\n Pc_LIDS,\n Pc_IsCf\n)\nSELECT\n 653,\n ISNULL(Pl_GxSort1, ''),\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),\n ISNULL(MAX(pl_order), 0) pl_order,\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),\n 0,\n ISNULL(Pl_GxSort1, ''),\n ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0),\n 1,\n 0,\n ISNULL(expr),\n '欧国冬',\n '6515',\n 1\nFROM wg_purchaselist_V001\nWHERE pid = 653\n AND Pl_GxSort1 = '06木工'\n AND (PLID IN (6515) OR Pl_GxSort3 = '欧国冬')\nGROUP BY Pl_GxSort1, ISNULL(ROUND(SUM(IFNULL(pl_GXValue, 0)), 1), 0)
原文地址: https://www.cveoy.top/t/topic/pK6c 著作权归作者所有。请勿转载和采集!