I did two query, can someone explain what happened?
First query: mysql> select * from customer_billing where first_name="shad"; +--------------+-------+------------+-------------+-----------+-------+- ---------+-----------+--------------------------+----------+----------+- ---------+-------+----------------+---------+-------------+------------- ---------------------+---------+--------+ | customer_num | title | first_name | middle_name | last_name | email | dayphone | evenphone | address1 | Address2 | address3 | address4 | city | state_province | country | CompanyName | pkey | zipcode | bldgID | +--------------+-------+------------+-------------+-----------+-------+- ---------+-----------+--------------------------+----------+----------+- ---------+-------+----------------+---------+-------------+------------- ---------------------+---------+--------+ | NULL | NULL | NULL | Tempe | Arizona | USA | NULL | D5BC55546AC74547EE497D4F559607DF | 85281 | NULL | +--------------+-------+------------+-------------+-----------+-------+- ---------+-----------+--------------------------+----------+----------+- ---------+-------+----------------+---------+-------------+------------- ---------------------+---------+--------+ 1 row in set (0.00 sec) It returned 1 row, and the first_name is NULL along with some other fields. How did it find that row when the fields are NULL? Second query: mysql> select first_name, customer_num from customer_billing where first_name="shad"; +------------+--------------+ | first_name | customer_num | +------------+--------------+ | Shad | 101706 | +------------+--------------+ 1 row in set (0.01 sec) Now these query is the same except for the '*'? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
