I was trying to do something like this:
CREATE PROCEDURE `UpdateField` (FieldName VARCHAR(45), NewValue VARCHAR(45))
BEGIN
UPDATE users SET FieldName=NewValue;
END
I get a runtime error saying the field "FieldName" does not exist - I need the SP to look into what's stored in FieldName and not treat it literally. Is it possible?
CREATE PROCEDURE `UpdateField` (FieldName VARCHAR(45), NewValue VARCHAR(45))
BEGIN
UPDATE users SET FieldName=NewValue;
END
I get a runtime error saying the field "FieldName" does not exist - I need the SP to look into what's stored in FieldName and not treat it literally. Is it possible?