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 ;) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]