我尝试使用下面的存储过程在MySQL的动态表中插入数据,但在使用以下命令调用它时遇到错误:
CALL insert_data ('table_x', 'NULL', 'A', 'B', 'C', 'D', 'E ')
错误
Column unknown' 0 'in the list of fields.
操作步骤
DELIMITER $$
CREATE PROCEDURE insertar_datos (name VARCHAR(25), N INT, AP
VARCHAR(15),
AM VARCHAR(15), Nom VARCHAR(30), DNI VARCHAR(8), Direc VARCHAR(30))
BEGIN
SET @tableName = Name;
SET @NName= N;
SET @APName = AP;
SET @AMName = AM;
SET @NomName = Nom;
SET @DNIName = DNI;
SET @DirecName = Direc;
SET @q = CONCAT('
INSERT INTO `' , @tableName, '` VALUES(
`',@NName,'`,
`',@APName,'`,
`',@AMName,'`,
`',@NomName,'`,
`',@DNIName,'`,
`',@DirecName,'`
)
');
PREPARE stmt FROM @q;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END $$
DELIMITER;
https://stackoverflow.com/questions/54972244
复制相似问题