Answers for "add multiple columns mysql"

addition of 2 column value in mysql

select *,(maths + chemistry + physics ) AS total FROM `student`

how to add more columns to a table in mysql

CREATE TABLE IF NOT EXISTS vendors (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255)
);
ALTER TABLE vendors
ADD COLUMN phone VARCHAR(15) AFTER name;