MySQL DESCRIBE INTO OUTFILE with windows command-prompt

Question

I want to print the structure of a table fomr my database.
Now I use the mysql command:

DESCRIBE products;

But how do I get this output into a txt file? Like:

DESCRIBE products; > products.txt

Related, if it's of interest, I wrote a *Describe All Tables* in [this Answer](http://stackoverflow.com/a/38679580). — Drew, Jul 31 '16 at 00:47

score 2 · Accepted Answer · answered Mar 24 '14 at 20:50

2

mysql -u username -p -e 'DESCRIBE databasename.tablename' > output.txt

answered Mar 24 '14 at 20:50

Sammitch

1 Answers1