 <pre><code> ALTER TABLE table_name ADD COLUMN column_name datatype </code></pre> <p>correct syntax </p> <pre><code>ALTER TABLE `WeatherCenter` ADD COLUMN BarometricPressure SMALLINT NOT NULL, ADD COLUMN CloudType VARCHAR(70) NOT NULL, ADD COLUMN WhenLikelyToRain VARCHAR(30) NOT NULL; </code></pre> <p>check <a href="http://dev.mysql.com/doc/refman/5.1/en/alter-table.html">syntax</a> </p>