Tag Archives: database

Basic Concepts of Database

In this post we will know some basic concepts  of database which includes different types of databases, schema, SQL , queries and table expressions. What is a Database? A database is any collection of related data. The database stores all data in tables that are related to one another. Relationships are established between tables such… Read More »

MySQL : Find databases size

In this post we will know how to find out the databases size in the MySQL server. MySQL Select Query to find database sizes :- SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”FROM information_schema.TABLES GROUP BY table_schema ; The above query will list out… Read More »