How to insert a particular coulmn in table.

A

arunachalam.arcot

I have a table, where i need to insert values only for one particular
column and teh other column will be manually or will be populated
through another queries. I'm kind of having difficuly in this. I tried
"Insert into " with select statements and also Select Inot, both does
not solve this, because they append a new row insted of inserting it in
a specific row. Any help will be highly appreciated.

Thanks
 
M

MGFoster

I have a table, where i need to insert values only for one particular
column and teh other column will be manually or will be populated
through another queries. I'm kind of having difficuly in this. I tried
"Insert into " with select statements and also Select Inot, both does
not solve this, because they append a new row insted of inserting it in
a specific row. Any help will be highly appreciated.
Click to expand...

Use the UPDATE statement. E.g.:

UPDATE table_name
SET column_name = some_value
WHERE <criteria>
 
Top