Oct 13, 2017

Get MySQL Database columns and datatypes

To get database details for specific database under MySQL use the following script. Execute the script in any DB tools like DBeaver etc.

select * from information_schema.columns
where table_schema = 'your_database_name'

No comments:

Post a Comment