Either I don't understand your reply or I miscommunicated. How do I do that when it is the tables that I want to select; that is *all* tables that are called "xyz$variable", where "variable" is unknown but all tables begin "xys$"? TIA, Victor
On Dec 31, 2007 3:59 PM, mos <[EMAIL PROTECTED]> wrote: > At 12:51 PM 12/31/2007, you wrote: > >Hi; > >Is it possible to sort tables within a given database? How? > >TIA, > >Victor > > Victor, > You mean physically sort the table based on a field or key so you > don't have to do an Order By clause each time you do a Select? Not really > because the order of the table is expected to be random unless you > specify an Order by clause. The only thing I can think of is to create a > new table, maybe temporary or Memory table and copy the data into it > already sorted. > > drop table if exists newtable; > create newtable like oldtable; > insert into newtable select * from oldtable order by col1, col2; > > Now you should be able to > > Select * from NewTable; > > without sorting (if you don't update it). The order should be by > col1,col2. > (No guarantee) > > If you want to sort it in order to speed it up, then run an Optimize on > the > table. > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
