SET @tmpUpdatesqls = CONCAT('UPDATE ',WeekTable,' SET TCount = ',CONVERT(@TCountTimes, CHAR), 'CTCount = ' ,CONVERT(@TCountTimes, CHAR), ' WHERE playerid =' ,CONVERT(inplayerid, CHAR));
PREPARE stmtUpdateWeek FROM @tmpUpdatesqls;
EXECUTE stmtUpdateWeek;
DEALLOCATE PREPARE stmtUpdateWeek; 为什么会报 Unknown column '2CTCount' in 'field list'的错误
我有CTCount的字段而我去掉CTCount就能执行 SET @tmpUpdatesqls = CONCAT('UPDATE ',WeekTable,' SET TCount = ',CONVERT(@TCountTimes, CHAR), ' WHERE playerid =' ,CONVERT(inplayerid, CHAR));
PREPARE stmtUpdateWeek FROM @tmpUpdatesqls;
EXECUTE stmtUpdateWeek;
DEALLOCATE PREPARE stmtUpdateWeek;
PREPARE stmtUpdateWeek FROM @tmpUpdatesqls;
EXECUTE stmtUpdateWeek;
DEALLOCATE PREPARE stmtUpdateWeek; 为什么会报 Unknown column '2CTCount' in 'field list'的错误
我有CTCount的字段而我去掉CTCount就能执行 SET @tmpUpdatesqls = CONCAT('UPDATE ',WeekTable,' SET TCount = ',CONVERT(@TCountTimes, CHAR), ' WHERE playerid =' ,CONVERT(inplayerid, CHAR));
PREPARE stmtUpdateWeek FROM @tmpUpdatesqls;
EXECUTE stmtUpdateWeek;
DEALLOCATE PREPARE stmtUpdateWeek;
用
SELECT @tmpUpdatesqls看看SQL语句是否正确
空格的位置错了吧?
ctcount 前边的空格