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 > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
