10.0.103 sql语句 json_table数据库中可以执行，活字格不行

登录

如下语句在navicat执行，mysql中有更新，同样复制到活字格中的执行sql命令，缺没有更新

INSERT INTO `领星listing` (`店铺id`, `MSKU`, `重量标准`, `FGC_LastModifyDate`)
SELECT
tt.`dianpuid` AS `店铺id`,
tt.`MSKU`,
'test' AS `重量标准`,
NOW() AS `FGC_LastModifyDate`
FROM
JSON_TABLE (
'[{"MSKU":"Amazon.Found.B0B92NGJLP","店铺id":7474},{"MSKU":"FN-004","店铺id":7474},{"MSKU":"FN-005","店铺id":7474},{"MSKU":"HTK-001","店铺id":7474},{"MSKU":"HTK-003-4Blue","店铺id":7474},{"MSKU":"HTK-003-4Green","店铺id":7474},{"MSKU":"HTK-003-4Purple","店铺id":7474},{"MSKU":"HTK-Colors3","店铺id":7474},{"MSKU":"MT-FP-A6-12","店铺id":7474},{"MSKU":"MT-FP-B6-15","店铺id":7474},{"MSKU":"MT-GM-ZJT-1554","店铺id":7474},{"MSKU":"MT-HTK-Black5-N","店铺id":7474},{"MSKU":"MT-HTK-Brown5","店铺id":7474},{"MSKU":"MT-HTK-Brown5-N","店铺id":7474},{"MSKU":"MT-HTK-Colors5-2-N","店铺id":7474},{"MSKU":"MT-HTK-Colors6-2-N","店铺id":7474},{"MSKU":"MT-HTK-Colors6-3-N","店铺id":7474},{"MSKU":"MT-HTK-Colors6-4-N","店铺id":7474},{"MSKU":"MT-HTK-Red5-N","店铺id":7474},{"MSKU":"MT-JAJ-LK-13421","店铺id":7474},{"MSKU":"MT-JF-JZJ-JF0451","店铺id":7474},{"MSKU":"MT-JF-JZJ-JF0488","店铺id":7474}]',"$

" COLUMNS (
   `dianpuid` BIGINT PATH "$.店铺id",
   `MSKU` VARCHAR(190) PATH "$.MSKU"
)
  ) AS tt
ON DUPLICATE KEY UPDATE
  `重量标准` = VALUES(`重量标准`),
  `FGC_LastModifyDate` = VALUES(`FGC_LastModifyDate`);

Lay.Li · Lay.Li

您好，您的数据表结构具体是什么样子的呢，然后在活字格中是如何使用的呢，建议您可以发一个demo上来，我们看一下您demo中的设置，这样我们也可以更好的帮助到您

		自动登录	找回密码
密码			立即注册

[已处理] 10.0.103 sql语句 json_table数据库中可以执行，活字格不行

1 个回复

活字格认证

活字格高级认证

微信认证勋章

悬赏达人