Ahh okay the column was cut off or something \G shows it!
Thanks!!
-Original Message-
From: Rich Lafferty [mailto:[EMAIL PROTECTED]
Sent: Friday, April 29, 2005 10:28 AM
To: mysql@lists.mysql.com
Subject: Re: Can someone explain strange query!!
On Fri, Apr 29, 2005 at 10:46:16AM
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 | A
[snip]
I did two query, can someone explain what happened?
First query:
mysql> select * from customer_billing where first_name="shad";
mysql> select first_name, customer_num from customer_billing where
first_name="shad";
Now these query is the same except for the '*'?
[/snip]
http://dev.mysql