Introduction As of MySQL 5.0 built-in (native) functions, user-defined functions and stored functions are now supported by the mysql engine. Although these functions are widely available to the developer their use isn’t fully exploited. In this article I am going to present the top MySQL functions that come in handy. Hash...
read more
A few times I came across the need to check if a current row exists in the database and then update it or if it doesn’t exist simply insert it. There are many ways you can achieve that, I’m gonna show you two of them and make a comparison between them. Before we move further you should know that I’m using Microsoft...
read more
What is RSS? RSS is a technology that is being used by millions of web users around the world to keep track of their favorite websites easily and efficiently. RSS stands for ‘Real Simple Syndication’ and many people describe it as a ‘news feed’ that you subscribe to. Basically it’s the internet’s...
read more
Why would we need a random row from the database ? Many sites need to get some random values from the database, for example to show a random imagine, quote or in case of online stores to show random products. The first method Probably the simplest method is to use the build-in function RAND() in your query. SELECT * FROM `table`...
read more