List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 22 2003 5:14am
Subject:Re: SHOW TABLES and ORDER
View as plain text  
At 23:36 -0500 3/21/03, Bernard Miville wrote:
>  Hi,
>
>  I am using MySQL 3.23.
>  I use SHOW TABLES to obtain a list of tables from my database and
>  then put this list in an HTML select form on a web page. What I need
>to
>  know, is there a way of obtaining this table list, using SHOW TABLES,
>  in ascending or descending order the same way you would do using
>  SELECT  for a field in a specific table and then ORDER BY?

No, sorry.  You have to sort them in your script.

>
>  Thank you for any help,
>
>  Bernard


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
SHOW TABLES and ORDERBernard Miville22 Mar
  • Re: SHOW TABLES and ORDERPaul DuBois22 Mar