Copy 1 column to another by mysql query August 12, 2023 by Tarik UPDATE mytable SET tax = amount after you can remove it ALTER TABLE mytable DROP COLUMN amount;