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
Answer Posted / jyothi
alter the table -> alter table <table name> <datatype>
after then u can insert values in that clounm bu using
UPDATE ...
update set column name= value where condition
condition ....where u want to update the value means which
row...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is isam? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Can we use pl sql in mysql?
Name three sql operations that perform a sort.
Explain how exception handling is done in advance pl/sql?
Can triggers stop a dml statement from executing on a table?
How is a PL/SQL code compiled?
What is union and union all keyword in sql?
Why is sql*loader direct path so fast?
What is union, minus and interact commands?
What is rtm in testing?
What are the set operators in sql?
What is triggering circuit?
what are the 'mysql' command line arguments? : Sql dba
What is a call statement? Explain with an example.