Setting root password for Mysql server on Linux
In some Linux installations, installing mysql-server does not prompt for a root password for mysql, thus creating the problem where you either run mysql under […]
MySQL
Socrates – web based MySQL schema diagram generator (now version 1.0)
WHAT IS SOCRATES Socrates is a web based application which generates a database schema diagram. It is written in PHP and uses JQuery in the […]
Querying float fields in mysql
Common mistake when querying float fields is to use the equal sign eg. select * from table where amt = 19.99 This never works because […]
Complete solution to migrate a large database sql file in MySql
During my recent project, i was in a situation where I had to move a large mysql database from a testing server to live server. […]