MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Pete Harlan Date:July 19 2004 6:19pm
Subject:Re: NULL problem
View as plain text  
It might help if you say what version of MySQL you're using, give the
table schema, etc.  I couldn't reproduce the behavior you describe
here.

--Pete


On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote:
> Hi,
> 
>  
> 
> I have a table with a column that has the Unique key constraint on it.
> In the table definition that column has a default NULL specification
> too.
> 
>  
> 
> So, when I ran the query select * from table where col is NULL;
> 
>  
> 
> I get only 1 row returned, when I have 23 such rows with NULL values.
> This might be because of the Unique Key constraint. Is there a query
> that will return all those 23 rows.
> 
>  
> 
> Thanks,
> 
> Deepak
> 
>  
> 
>  
> 
Thread
NULL problemDeepak Vishwanathan19 Jul
  • Re: NULL problem(Pete Harlan)19 Jul
RE: NULL problemThomas P Sommerfield19 Jul