MySQL: Copy table structure to excel using Sequel Pro
Just run this command and copy all results:
describe table_name;Or if need more infomation about structure:
SELECT * from information_schema.columns WHERE table_schema = 'database_name' AND table_name = 'table_name';
Or export to file:
SELECT * from information_schema.columns WHERE table_schema = 'database_name' AND table_name = 'table_name' INTO OUTFILE '/tmp/export.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n';