On Fri, Apr 29, 2005 at 10:46:16AM -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I did two query, can someone explain what happened?
Not with what you included: > | customer_num | title | first_name | middle_name | last_name | email | > dayphone | evenphone | address1 | Address2 | address3 | > address4 | city | state_province | country | CompanyName | pkey > | zipcode | bldgID | 19 columns. > | NULL | NULL | NULL | Tempe | Arizona | USA | > NULL | D5BC55546AC74547EE497D4F559607DF | 85281 | NULL | 10 columns, presumably the line with "address" and "zipcode", not the line with "first_name" and so forth. > How did it find that row when the fields are NULL? I believe it isn't. Do the query with "\G" instead of ";" on the end so that you see what values are in which columns. -Rich -- Rich Lafferty --------------+----------------------------------------------- Ottawa, Ontario, Canada | Save the Pacific Northwest Tree Octopus! http://www.lafferty.ca/ | http://zapatopi.net/treeoctopus.html [EMAIL PROTECTED] -----------+----------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]