M.M.Stephin Nadar's Blog

you can download GeoIP csv database from http://www.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip unzip  and extract the csv fil...

Table Structure and Data employer_id    salary 111              1000 112              2000 113              1000 111              100...

ps -ef | grep mysql - checks if mysql / mysqld is one of the running processes.       pkill mysqld - kills the daem...

alter table tablename add unique index ( column1,column2,column3 );

SELECT * FROM (     SELECT * FROM table1     ORDER BY nos desc limit 0,1 )           )  T1 ORDER BY RAND ()         usage: if ...

SELECT * , COUNT( ref ) AS occurances FROM table GROUP BY ref ORDER BY occurances DESC