Re: Is there a simplified code than this?
From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Tue, 29 Jun 1999 19:27:57 GMT
Message-ID: <37791FC6.41224DD_at_sympatico.ca>
Date: Tue, 29 Jun 1999 19:27:57 GMT
Message-ID: <37791FC6.41224DD_at_sympatico.ca>
Nop, looks pretty simple to me.
Qingbo Zheng wrote:
> UPDATE cadsrdb.population
> SET births = NULL,
> deaths = NULL,
> net_migration = NULL,
> international = NULL,
> domestic = NULL,
> federal = NULL,
> residual = NULL
> where births = 0 OR
> deaths = 0 OR
> net_migration = 0 OR
> international = 0 OR
> domestic =0 OR
> federal = 0 OR
> residual = 0
Received on Tue Jun 29 1999 - 21:27:57 CEST