Update 1

[CIMTEET]

Will this update all records that meet this condition or just the first one?

UPDATE temp_id_map SET condition = 0 WHERE object_id > 0;

GREG

 

[carp]

It will update all rows that meet the WHERE conditions.

 

[CIMTEET]

What if there are no WHERE conditions? Then it will populate all records with fields called 'condition'? I know these are simplistic questions. I am new to this and converting a program that is using declared temp tables to using existing tables in the database. THanks for your help.

Greg

 

[carp]

It will update every row in the temp_id_map table. If that table does not have a column called "condition", then the command will throw an exception and nothing will be updated.