Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

what is isam? : Sql dba

990


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

954


Can we use pl sql in mysql?

1000


Name three sql operations that perform a sort.

989


Explain how exception handling is done in advance pl/sql?

987


Can triggers stop a dml statement from executing on a table?

1068


How is a PL/SQL code compiled?

1208


What is union and union all keyword in sql?

1021


Why is sql*loader direct path so fast?

1094


What is union, minus and interact commands?

1275


What is rtm in testing?

1096


What are the set operators in sql?

1060


What is triggering circuit?

1052


what are the 'mysql' command line arguments? : Sql dba

1122


What is a call statement? Explain with an example.

993