Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 12289 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
How delete all data from table in sql?
explain primary keys and auto increment fields in mysql : sql dba
What is bind reference and how can it be created?
Which is better join or inner query?
Is sql the best database?
What is crud sql?
How do I turn a list into a table?
How to Declare Fixed Length String Value In PL SQL
What is an escape character in sql?
What is pl sql and why it is used for?
what is online transaction processing (oltp)? : Sql dba
What is left inner join in sql?
What are commit, rollback, and savepoint?
When is the update_statistics command used?
Which command is used to delete a package?
