THANKS ALL for the tremendous response. It is really helping me a
lot
I have another query.
Can the output of the DESCRIBE be stored somewhere ( in file)?
I suppose the DESCRIBE query doesn't return the result set.
Or is there any way to get the structure of whole table?
Regards
'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
On Friday 11 August 2006 08:25, [EMAIL PROTECTED] wrote:
Can the output of the DESCRIBE be stored somewhere ( in file)?
mysql mydb 'describe table' table.describe.txt ?
Or is there any way to get the structure of whole table?
show create table?
--
Scanned by iCritical.
--
MySQL General