Its now very easy to delete all the duplicate entries from mysql with a single query

To join 3 or more tables in mysql first you have to make sure that your tables have unique id and a primary field.

Converting mysql datetime data to proper rss valid data like : Wednesday, July 14, 2010 7:27 AM

If you ever encounter a problem when mysql database is migrated from one server to another with uploading manually .myd files.

Follow the below steps to easily reset the root database password even if you have lost it: