How to add a new column in my already created table using sql command

Question

How can I add a new column (like email) in my already created table students using sql command?

In my students table I already have two columns name id and name. It was created using this sql command

CREATE TABLE students(id INT AUTO_INCREMENT, name VARCHAR(255), PRIMARY KEY id);

Welcome to StackOverflow. I corrected your little language mistakes, hopefully it's really what you intended to ask. — René Vogt, Dec 30 '16 at 11:06

score 5 · Accepted Answer · answered Dec 30 '16 at 11:02

5

You can use ALTER statement to add new column in existing table.

ALTER TABLE students ADD email VARCHAR(100);

answered Dec 30 '16 at 11:02

Samir Selia

Thanks for your answer. it was greate and sloved. – Jonayed Islam Dec 30 '16 at 11:07

1 Answers1