Re: [Debconf-team] blanking bank information from penta
Richard Darst dijo [Tue, Jun 28, 2011 at 04:56:39PM -0400]:
> And here is the code:
> UPDATE person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
> To blank logs, too:
> UPDATE log.person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
> It might be wise for someone who claims to know SQL (not me) check
> these. I'm also not sure if I missed something obvious here making
> the code invalid...
Oh, and FWIW - your queries look sane. The BEGIN and COMMIT statements
are not needed, but won't hurt.