title: Adding multiple columns in MySQL with one statement
body: <p>I am trying to add multiple columns to an existing table in phpMyAdmin, but I keep getting the same error:</p>
  
  <blockquote>
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax ...</p>
  </blockquote>
  
  <p>I am writing:</p>
  
  <pre><code>ALTER TABLE `WeatherCenter`
     ADD COLUMN
        BarometricPressure SMALLINT NOT NULL,
        CloudType VARCHAR(70) NOT NULL,
        WhenLikelyToRain VARCHAR(30) NOT NULL;
  </code></pre>
  
  <p>I have referred to past posts on StackOverflow, and I am following the experts' recommendation, so why am I getting an error?</p>