mysql - SQL 传递时参数索引超出范围(1 > 参数数量，即 0)？查询中的参数

Question

INSERT INTO JOB_AUDIT_HDR_LOG (APP_NM,BTCH_NUM,BTCH_RUN_STRT_TM,BTCH_RUN_STS_CD)
SELECT ? AS app_nm,
       COALESCE(btch_num, 0) + 1 AS batch_num,
       Now(),
       'RUNNING'
FROM   (SELECT 1) Dt1
       LEFT OUTER JOIN(SELECT app_nm,
                              MAX(btch_num) AS btch_num
                       FROM   gmicntrldb.JOB_AUDIT_HDR_LOG
                       WHERE  app_nm = ?
                       GROUP  BY app_nm)Dt2
                    ON 1 = 1;

运行此查询时出现错误，例如参数索引超出范围(1 > 参数数量，为 0)。

Answer 1

您有 2 个？，这意味着您需要传入一个参数数组，其中包含 [0] 和 [1] 条目。看来您在 param 数组中只传递了 1 个(也可能是 0 个)参数？