hi Alter Table <Table Name> ADD( <Column name> <data ty

I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Question Posted / ramprasad.s

9 Answers
11959 Views
I also Faced
E-Mail Answers

Answer Posted / ramprasad.s

hi

Alter Table <Table Name> ADD( <Column name> <data type>)

you can insert values by using <update> with reference

to the existing values of the other columns.
bye

sun_ramprasad@yahoo.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain unique key in sql.

1001

Does mysql_real_escape_string prevent sql injection?

944

Explain some predefined exceptions.

1027

How do I filter in sql profiler?

990

Why truncate is faster than delete?

1102

What is difference between sql and mysql?

1117

how to use regular expression in pattern match conditions? : Sql dba

1021

What is the max nvarchar size?

959

What plvcmt and plvrb does in pl/sql?

1307

What is pl sql record in oracle?

1021

What is the mutating table and constraining table?

1023

What are joins in sql?

1039

What is the difference between a subquery and a join?

1094

What does closing a cursor do?

1313

What is java sql driver?

1107