Sometimes you need to know the size of each mysql table to optimize them and gain some free space in the disk. To do so, you can check manually the size of each table in the mysql datadir (generally it is /var/lib/mysql), or you...
Read MoreToday I come across with a complex sql query requirement where I have to filter a table on a column entry and then sort according to date. The SQL language have some inbuilt keywords like ORDER to sort out this type of issues....
Read MoreThe most popular database(DB) software known to man is Oracle. There are some other commercial and open source Databases such as1. MS-Sql(from Microsoft)2. DB2(from IBM)3. PostgreSQL(it’s a open source SW) 4. Mysql(my...
Read More
My name is Surendra Kumar Anne. I hail from Vijayawada which is cultural capital of south Indian state of Andhra Pradesh. I am a Linux evangelist who believes in Hard work, A down to earth person, Likes to share knowledge with others, Loves dogs, Likes photography. At present I work at Bank of America as Sr. Analyst Systems and Administration. You can contact me at surendra (@) linuxnix dot com.