SUCCESS:Re: Can I use a parameter for a colum name ?

[Burt Stewart]

success (see sproc below)
So as Santa said "Yes Virginia, you CAN use a parameter for a colum name"

My errors were:
1. the CONCAT syntax, it needs the substrings separated by comma !
2. customerID is an int not a string

happy holidays to all


DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test_procedure`(IN ColumnNameParam varchar(10) )
BEGIN
set @ColumnName = ColumnNameParam;
set @s = CONCAT("UPDATE customer set ", @ColumnName, " = 'Test of ColumnNameParam' WHERE customer_id = ", 1);
PREPARE stmt FROM @s;
EXECUTE stmt;
END