Alter multiple columns in a single statement [duplicate]

mysql sql alter-table mysql-error-1064

Solution 1:

The documentation suggests you can chain alter_specifications with a comma:

ALTER TABLE `media_value_report` 
    CHANGE col1_old col1_new varchar(10),
    CHANGE col1_old col1_new varchar(10),
    ...

Related

Rails includes with conditions
Mapping homotopic to the identity map has a fixed point
An unclear sentence in the book "Griffiths, Harris-Principles of algebraic geometry"
Is an increasing, bounded and continuous function on $[a,+\infty)$ uniformly continuous?
What is the general formula of the sum $\sum_{k=0}^{n}(-1)^{k} \binom{n}{k}\binom{k/2}{m}$ for $m,n\in\mathbb{N}$?
How can I find $\int\frac1{\sqrt[4]{1+x^4}}\mathrm dx$?
maximum modulus principle implies Liouville's Theorem
Decomposition of a homogeneous polynomial
What can we say about a locally compact Hausdorff space whose every open subset is sigma compact?
Determining whether a certain element in a tensor product is zero
Exclusion Inclusion Principle Induction Proof
Aren't asteroids contradicting Euler's rotation theorem?