How to pass mysql procedure argument to column name?

Question

MySQL

There is a procedure:

CREATE DEFINER = 'root'@'%'
PROCEDURE db.admin_change_product(
  IN infield varchar(255),
  IN invalue varchar(255),
  IN inidProduct int
  )
BEGIN
  UPDATE goods g SET g.infield = invalue WHERE g.id = inidProduct;
END

When executed, it gives:
Unknown column 'g.inField' in 'field list'
I tried to put ``:

UPDATE goods g SET `inField` = inValue WHERE `id` = inIdProduct;

The same.
What could be the problem?

Answer 1

You are essentially trying to make a dynamic query (specify the names of columns, tables, etc. at runtime), but as you wrote it will not work. In MySQL, the only way to create dynamic queries is to collect them as strings and then execute them like this:

SET @myquery := CONCAT("UPDATE goods SET ", infield, " = ", invalue, " WHERE id = ", inidProduct);
PREPARE myquery FROM @myquery;
EXECUTE myquery;
DEALLOCATE PREPARE myquery;