I'm trying to move data (update) from two columns into one. Want to slim down my database and get rid of unnecessary columns.
So far I have tried this
UPDATE db SET firm = firm_stone AND firm_concrete
UPDATE db SET firm = firm_stone, firm_concrete
UPDATE db SET `firm` = `firm_stone`, `firm_concrete`
You have to concatenate these 2 column's value to a single string to keep that in a same column.
UPDATE db.tablename SET firm = concat_ws(' ',firm_stone, firm_concrete);
' ' a blank space will be placed with the 2 strings. You can use your own.