Posts Under ''

PHP Script to Optimize All Tables In A MySQL Database

In MYSQL OPTIMIZE TABLE should be used if you have deleted a large part of a table or if you have made many changes to a table with variable-length rows. Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused […]

Read more »

How to calculate the difference between two dates in java

long diffInMilleseconds = end.getTime() – start.getTime(); // end and start are timestamps long noofdays=diffInMilleseconds/86400000; long diffInSeconds = diffInMilleseconds/1000; long diffInMinutes = diffInSeconds/60; long diffInHours = diffInMinutes/60; long diffInDays = diffInHours/24;

Read more »