how to add multiple columns to existing table in sql code example
Example 1: add multiple columns to table sql
//Example
ALTER TABLE employees
ADD last_name VARCHAR(50),
first_name VARCHAR(40);
Example 2: add multiple field in table sql
ALTER TABLE employee
ADD (
last_name VARCHAR(50) NOT NULL,
first_name VARCHAR(40) NOT NULL
);