1. alter table <table_name> add column<col_name> <data

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 / manoj

9 Answers
11668 Views
I also Faced
E-Mail Answers

Answer Posted / manoj

1.
alter table <table_name>
add column<col_name> <data_type>[not null];

2.
for inserting values

Depends: if u have data in another table than u can insert
by making small packege (using cursor)

OR :u can also sequence to insert

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is java sql connection?

963

What are sql injection vulnerabilities?

908

explain access control lists. : Sql dba

946

What is before trigger?

943

how to include numeric values in sql statements? : Sql dba

1038

What does <> sql mean?

981

What do you mean by “trigger” in sql?

1015

What is where clause in sql?

980

explain the delete statements in sql

973

How do sql triggers work?

982

Which is faster view or stored procedure?

886

How many sql statements are used?

955

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1002

What is the difference between a primary key and a clustered index?

926

How do I view tables in mysql?

912