Singleton design pattern ensures that only a single object is created even in multiple thread environments. It is a widely used design pattern in object oriented programming languages including Java.

There are many situations where we update multiple tables in a single transaction. In many cases you have to get the primary key value of the first record inserted in table 1 for updating/inserting record in second table. MySQL provides a handy function exclusively for this purpose.