what should I do to add new column to the table ?

Answer 1

Graphyically you can do.

If you need to add using Query you can try this

Alter Table TableName
add ColumnName datatype;

for example if I want to add ColumnName Say Name in Student Table then

Alter table Student
add Name Varchar(20);

Answer 2

It is ALTER table ie you are modifying in table structure DDL(Data Definition Language) query not DML(Data Manipulation Language).

Answer 3

If u care about the position of the column being added, then u can use the following syntax:

ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ]

E.g.:

Alter Table Person
Add Column MiddleName VARCHAR(100) AFTER FirstName

Answer 4

you should read 8th block in 3rd lesson from sql course "sololearn sql"

Answer 5

correct

Answer 6

Use Alter

Answer 7

enth