From: Martin Friebe
Date: March 16 2007 7:42pm
Subject: select *, more_fields
List-Archive: http://lists.mysql.com/internals/34398
Message-Id: <45FAF32F.4070702@hybyte.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I believe to remember there have been feature requests, about the 
placement options for the * in the select
( http://bugs.mysql.com/bug.php?id=26066 )

currently the * must be the first in the list.
 select *, field from table => ok
 select  field, * from table => not ok

This appears to be fixable in the parser with little effort.
So the questions are:
- Is it SQL standard conform?
- Is it a feature that would be wanted?

If it is "yes", I can supply a patch.

One more question, if "yes"

Should 
  "select *, * from table" be allowed?
My first thought would be "no", but then you can already do:
  "select table.*, table.* from table from table"

Any thought?

Best Regards
Martin