Tag: Select (SQL)

Feb 12

How to: Get the size of your Databases in MySQL Query Browser

How to: Get the size of your Databases in MySQL Query Browser Imagine you want to transfer data from one server to another and you need to know the size of the databases you are thinking of transfering. Unlike Microsoft SQL Server which graphical interface allows you to see the size of the database files …

Continue reading »

Dec 21

MySQL: How to list all available tables in the system

MySQL: How to list all available tables in the system Because sometimes you just need to know (the available tables are out there so you can use that list in a script). If you are running MySQL Workbench you can execute the following SQL Query and export the results to a file: select table_name from …

Continue reading »