List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 22 2003 5:14am
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
>  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
sql, query
SHOW TABLES and ORDERBernard Miville22 Mar
  • Re: SHOW TABLES and ORDERPaul DuBois22 Mar