Updating a specific cell in a SQL database

  • Thread starter Thread starter zoneal
  • Start date Start date
Z

zoneal

Here's what's happening. I need to take a value, and insert it into an
already-created row in a SQL database. The methods I know of only add
rows to the end, therefore I cannot edit information. If I know the
index for the row to be edited, how can it be done? Help would be much
appreciated.
 
Here's what's happening. I need to take a value, and insert it into an
already-created row in a SQL database. The methods I know of only add
rows to the end, therefore I cannot edit information. If I know the
index for the row to be edited, how can it be done? Help would be much
appreciated.
Click to expand...

I think you'd be better off asking in an SQL-related newsgroup. However,
you're looking for the UPDATE command, for example

UPDATE authors
SET state = 'PC', city = 'Bay City'
WHERE state = 'CA' AND city = 'Oakland'

Andrew
 
Back
Top