How to add values to other columns

[aardvax]

Hi Rafi,

As alter is a DDL command,you can not manipulate the table using alter.if you have to add one more column in table then u can make use of this.

but if you want to fill the columns of the table then you must have to use DML commands that is INSERT or UPDATE.

hi reeta
i jus thought that if we want to insert(not as SQL command) values into a particular cell then then it is better to use UPDATE as INSERT will add a row to the (means a record to the table)..
please correct me if i am wroooooooooong:-)

[reetasharma108]

ya.if u want to fill a colum u have to use update and for inserting new row then use insert.