Bug #10398 umm , FEATURE REQUEST
Submitted: 5 May 2005 21:33 Modified: 4 Aug 2005 21:35
Reporter: jon doe Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:newest OS:Any (all)
Assigned to: CPU Architecture:Any

[5 May 2005 21:33] jon doe 
Description:
SUGGESTION:

  Is have an   FROM *  , Or all   

this way we do not have to type in     SELECT account_names FROM them a , Them b , them c , them d ,  and all the other tables 

WHERE wootwoot=dootdoot    

so it would look through all the tables    WHERE ..   wootwoot=dootdoot 

Sorry if this has already been a suggestion , Already created 

How to repeat:
goto the thing and type in 

SELECT column_name FROM *  (meaning all tables in the database thats selected)  WHERE anothercolumn=something

then it will give ya an error 

Suggested fix:
make a FROM *   or something like this query 

This way we will not have to create a whole ton of  SELECT account_name FROM alltheaccountsinthedatabase, hereisanotherone, hereismore , moremoremoremore, wellwearegettingdownhere , yetanotherone, ourdatabaseishuge,withmanymanypeople,eachwiththeirowntable,isntthatcool , Etc Etc...
[4 Aug 2005 21:35] Jim Winstead 
This isn't going to happen. 'SELECT field FROM *' just doesn't make sense given the structure of the SQL language.