Copy values from one column to another in the same table
database, mysql
Solution
Short answer for the code in question is:
UPDATE `table` SET test=number
Here `table` is the table name and it's surrounded by grave accent (aka back-ticks `) as this is MySQL convention to escape keywords (and `TABLE` is a keyword in that case).
BEWARE!
This is pretty dangerous query which will wipe everything in column `test` in every row of your table replacing it by the `number` (regardless of it's value)
It is more common to use `WHERE` clause to limit your query to only specific set of rows:
UPDATE `products` SET `in_stock` = true WHERE `supplier_id` = 10
Problem
How can I make a copy values from one column to another? I have: ``` Database name: list ------------------- number | test ------------------- 123456 | somedata 123486 | somedata1 232344 | 34 ``` I want to have: ``` Database name: list ---------------- number | test ---------------- 123456 | 123456 123486 | 123486 232344 | 232344 ``` What MySQL query should I have?