Work around for solving round off issues when converting existing MySql Column from FLOAT to DOUBLE

Today I have noticed a strange behaviour of mysql database when I tried to convert mysql column type from FLOAT to DOUBLE. I had a MySql ... read more

Using both "sum" and "limit" in a mysql query

Recently I wanted to use both "limit" and "sum" in mysql query. "Sum" will return single value while "l... read more