Adding multiple columns in MySQL with one statement

database, mysql, sql

Solution

 ALTER TABLE table_name
 ADD COLUMN column_name datatype

correct syntax

ALTER TABLE `WeatherCenter`
   ADD COLUMN BarometricPressure SMALLINT NOT NULL,
   ADD COLUMN CloudType VARCHAR(70) NOT NULL,
   ADD COLUMN  WhenLikelyToRain VARCHAR(30) NOT NULL;

check syntax

Problem

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

Original source

Related problems