Twitter like N min/sec ago timestamp in PHP/MySQL
While working on one of the forum project, I had to print the timestamp of a topic in format “N Seconds ago” or “X minutes ago”.! The Web 2.0 world have changed the way...
MySQL Tutorials, Tips & Tricks
Fetch Random rows from Database (MySQL, Oracle, MS SQL, PostgreSQL)
Ever thought why would one need to fetch random rows from a database table? You may want to display some random information (like articles/pages/links) to your user. I had a requirement wherein I had...
Full-Text Search using MySQL: Full-Text Search Capabilities
Have you ever thought how does the search functionality is implemented in all the websites! Most of the internet blogs and websites are powered by MySQL database. MySQL provides a wonderful way (Full-text Search)...
Oracle buying Sun Microsystems: What will happen to MySQL!
The final words are out. Sun Microsystems have accepted the $7.4 billion offer by Oracle corporation. Oracle Corporation’s CEO Larry Ellison announced today the official word and so does the SUN’s website saying. Oracle...
Generating Tag cloud with PHP and MySQL
The basic idea this time is to present a way to form a tag cloud from user input text and text entered in the past. A tag cloud is a visual depiction of user-generated tags,...
MARIA, An extended MyISAM engine for MySQL
Let us talk about Maria.. no no not Maria Sharapova, its new version of MyISAM engine for MySQL which is claimed to be crash safe and provides more concurrency. It aims at becoming fully...
MySQL Database Backup using mysqldump command.
Since its release in 1995, MySQL has became one of the most commonly used database in Internet world. A lot of small and medium businesses uses MySQL as their backend db. Its popularity for...
How to: Reset MySQL root password
Resetting the root password of a MySQL database is trivial if you know the current password if you don’t it is a little trickier. Thankfully it isn’t too difficult to fix, and here we’ll...
Problem with comparison of float or double column in MySQL
Problem with comparison of float or double column in MySQL I had a problem in comparing the number with decimal point with a float column in MySql. After some investigation I came to know...
Get Autoincrement value after INSERT query in MySQL
Lot of time we have requirement to update two tables simultaneously. Say for example, we have two tables CUSTOMER_DETAILS and CUSTOMER_ADDRESS. While adding a row in CUSTOMER_DETAILS, few details like address is first written...