MySQL - if value in column then insert value in another column

Question

I want to do bulk update on my database. So I want to know how to insert value to the new column based on the value from other column. E.g.

If value in columnA = 15, then insert 'text' in columnB.

Thanks.

Abhik Chakraborty · Accepted Answer · 2015-03-07 17:54:33Z

2

Thats not insert, thats update,and you can do it as

update table_name
set 
columnB = 
case when columnA = 15 then 'text' end

answered Mar 7, 2015 at 17:54

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

Comments

myadlan · Accepted Answer · 2015-03-07 18:17:38Z

2

I've found the answer from almost similar question.

UPDATE table
SET columnB='text' where (columnA='15')

This is much more straight forward.

answered Mar 7, 2015 at 18:17

myadlan

1051 gold badge1 silver badge7 bronze badges

mysqlrockstar · Accepted Answer · 2015-03-07 18:29:28Z

1

UPDATE table SET columnB =  IF(columnA = 15, 'text',NULL);

answered Mar 7, 2015 at 18:29

mysqlrockstar

2,6301 gold badge21 silver badges39 bronze badges