Posts

mysql : database and table's - memory and data informations

Here I mentioned some basic SQL query for getting data information in DB and Tables level. For getting all database size and remaining space available in MB Query: SELECT table_schema "Data Base Name",     ROUND(SUM( data_length + index_length ) / 1024 / 1024 ,2) "Data Base Size in MB",      ROUND(SUM( data_free )/ 1024 / 1024,2) "Free Space in MB" FROM information_schema.TABLES GROUP BY table_schema ; OUTPUT: Data Base Name                                      Data Base Size in MB              Free Space in MB   ------------------                         ----------------...

JUnit Tutorial

JUnit   Tutorial JUnit is a unit testing framework for the Java programming language. JUnit has been important in the development of test-   driven development, and is one of a family of unit testing frameworks collectively known as xUnit that originated with JUnit. Download junit-4.10.jar  here Features 1.  JUnit is an open source framework which is used for writing & running tests. 2.  Provides Annotation to identify  the test methods. 3.  Provides Assertions for testing expected results. 4.  Provides Test runners for running tests. 5.  JUnit tests allow you to ...