Change a value of a record in whole database . URGENT

[MarioVITAL]

hi all
i have a table with a field that have a default value , now i change that value , but will only affect the news records ... my problem is to change the old value with the new one in all the records / field i have in my table..

this is very urgent

 

[piti]

update tablename set fieldname=newvalue ;-)

 

[swampBoogie]

update t set c = 'newValue' where c = 'oldValue'

 

[QatQat]

TRy somethign like this


update table_name set column_name = 'value' where ID IS NOT NULL


where ID is you r primary key

This will change every the value in a set column for every record that has got a not null key

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[QatQat]

Swampboogie,

I think your statement will only work if MarioVITAL has never modified any of the records and left the default value.

Mind you, my way is far from elegant... but it does the job.


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[swampBoogie]

Qatqat:

Yes, that is how I interpreted his question.

 

[QatQat]

Cool man

Mine was not a criticism

I would never say anything to the only one that has ever helped me when I posted my questions.


Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[MarioVITAL]

thz piti

works fine