Developer Snippet Diary

Get all columns Name from Mysql for all tables

select * from information_schema.columns
where table_schema = 'your_db'
order by table_name,ordinal_position
Posted by: R GONDAL
Email: rizikmw@gmail.com