Insert statment

[ashz]

How can I insert one value ("n&quot to one field in all the records.

 

[nigelcohen]

To "insert" a field, you use the "update" command, since the record is already in the database.

eg.
update NamesTable set FirstName = 'H' where UserID = '12'

If you don't already have a record in the database (in the above example, the record can be identified from its field UserID), you would need to insert the record

eg.
insert into NamesTable
(UserID, FirstName)
values
('12', 'H')

 

[KarveR]

to do all fields currently in the database:
update NamesTable set field_to_update = 'n' ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.