CODEWITHSUNDEEP
mysqlsqlphpmyadmin
Techie
Techie

Reputation: 45124

Export table description in PHPMyAdmin/MySQL

 DESC table_name

Above SQL allows me to get the table description in PHPMyAdmin. I want to export it to a text file or word file for the documentation. Is there a possible way to do it. Thanks.

Upvotes: 1

Views: 291

Answers (1)

Devart
Devart

Reputation: 121932

You can do it easily using SELECT...INTO OUTFILE statement reading data from information_schema.tables or information_schema.columns table -

SELECT * FROM information_schema.tables INTO OUTFILE dump_tables.csv

The query will output resultset into specified CSV-file.

Upvotes: 2

Related Questions