Victoria Reznichenko wrote:

On Friday 04 April 2003 18:20, Jason Joines wrote:



    Is there any way to combine MySQL commands?  For example I want to
display the columns and indexes from a table.  I can issue the two
commands on one line as

show fields from dbname.tblname; show index from dbname.tblname;

Is there some way to say

show fields and index from dbname.tblname;



SHOW CREATE TABLE helps you ;)



Thanks, that did the trick.


Jason
====================


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to