update table where column name is set as variable mysql

Question

I am creating a mysql statement that should update a table, but instead of setting a column name to be equal to some value the normal way, I decided to make it dynamic, for example instead of:

UPDATE mytable SET mycolumn = 'a value';

I use a variable. In this case:

SET @column = 'mycolumn';
UPDATE mytable SET @column = 'a value';

This returns a syntax error message when I execute the update statement. Is there a way to do this?

juergen d · Accepted Answer · 2012-06-25 13:53:55Z

1

you can do this:

set @query = 'UPDATE mytable SET @column = ''a value''';
set @query = replace(@query, '@column', 'col_name');
PREPARE stmt1 FROM @query;
EXECUTE stmt1;

answered Jun 25, 2012 at 13:53

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

update table where column name is set as variable mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related