List:General Discussion« Previous MessageNext Message »
From:Chris Date:March 12 1999 2:22pm
Subject:Re: MySQL and NULL entires
View as plain text  
It won't work to use 'NULL' as a parameter in an '=' comparison...use
ISNULL instead:

UPDATE ACCOUNT SET billgroup = '1' WHERE ISNULL(billgroup);

--Chris

On Thu, 11 Mar 1999, Mike Machado wrote:

> update account set billgroup = "1" where billgroup = "NULL";
> update account set billgroup = "1" where billgroup = NULL;
> update account set billgroup = "1" where billgroup = "";
> update account set billgroup = "1" where billgroup = '';
> update account set billgroup = "1" where billgroup = "0";

Thread
MySQL and NULL entiresMike Machado12 Mar
  • Re: MySQL and NULL entiresSasha Pachev12 Mar
  • Re: MySQL and NULL entiresThimble Smith12 Mar
  • Re: MySQL and NULL entiresChris12 Mar
  • Re: MySQL and NULL entiresChristian Mack12 Mar
  • Re: MySQL and NULL entiresKarl Pielorz12 Mar
  • Re: MySQL and NULL entiresEd Carp12 Mar
  • Searching for CEOs against software patents"Jonas Norrman6 Oct
  • Re: MySQL quota problemArjen Lentz21 Jan
Re: MySQL quota problemHeikki Tuuri21 Jan