Ok here's the situation that i need to resolve urgently. I have a table with 5 columns. One of those columns has data in it that should be encrypted that was erroneously left unencrypted. I need to go through 3000 rows and for each row, encrypt the value in that column. With me so far?
So essentially, i need to select that column, modify the value returned, and update the same column with the new value.
My question is how do i accomplish this? Being a web-focused programmer i immediately think of writing an ASP (or PHP) script that pulls the info out, modify it, then update the column. But, now i want to know if it's better (more efficient, faster, etc) to use a stored procedure, use PERL, or use any other method to accomplish what i wish to do, and how. Your input is greatly appreciated.
- sk
So essentially, i need to select that column, modify the value returned, and update the same column with the new value.
My question is how do i accomplish this? Being a web-focused programmer i immediately think of writing an ASP (or PHP) script that pulls the info out, modify it, then update the column. But, now i want to know if it's better (more efficient, faster, etc) to use a stored procedure, use PERL, or use any other method to accomplish what i wish to do, and how. Your input is greatly appreciated.
- sk