Can the output of the DESCRIBE be stored somewhere ( in file)?
You can store it where-ever you like. Mysql stores it in a binary file which you can't read (ie it's not like the my.cnf file).
I suppose the DESCRIBE query doesn't return the result set.
What are you after exactly? Using 'explain' doesn't return the results, it only shows you what mysql is going to do (whether it will use indexes or not for example).
Or is there any way to get the structure of whole table?
show create table 'tablename'; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
