mariadb - 如何在 Update 语句中将变量设置为列，当通过 Select 检索变量中的 columnName 到变量 mariadb

Question

DECLARE identifier INT(11);
DECLARE kundenNr VARCHAR(50);
DECLARE spalte VARCHAR(50);
DECLARE altValue VARCHAR(500);
DECLARE neuValue VARCHAR(500);

DECLARE counter INT(11);
SET counter =( SELECT COUNT(*) FROM tblkundenchangehistory WHERE ysnUpdated = 0);
IF counter <> 0 THEN

SELECT ID,intKundenNr,strColumn,strOldValue,strNewValue FROM tblkundenchangehistory WHERE ysnUpdated = 0 LIMIT 1
INTO identifier,kundenNr,spalte,altValue,neuValue;

UPDATE dbtestsync.tblkunde SET spalte   = neuValue WHERE strKundenNr = kundenNr;

UPDATE tblkundenchangehistory SET ysnUpdated = 1 WHERE ID = identifier;
END IF;

END

粗 斜体

当我更新 tblkunde 时引用设置 strFirma ="xxx" 其中 strKundenNr="xxx" 触发器显示未知字段 spalte

标签： mariadb