and are most likely to used when your playing with the subqueries in MySQL. So these will be used when you want to perform operation based on checking row existance of the other table or even same table. If sub query will return any value then EXISTS will be and NOT EXISTS will be . [...]

Read More...

CHAR vs VARCHAR in MySQL

By Avinash

December 05, 2011Tutorial4 Comments

and are the datatypes of the MySQL. This article is to cover similarity and difference of both datatypes. Both are almost same but for some aspects both behave slight different based on condition. Introduction CHAR and VARCHAR are almost same but both are different at the stage of storing and retriving the data from the [...]

Read More...

Row Locking With MySQL

By Avinash

November 27, 2011Tutorial5 Comments

MySQL has several types of Table Storage Engines. Each types can be used based on need. Like if your database has large number of READ operation rather than INSERT and UPDATE then its better to use MyISAM. But for large number of INSERT and UPDATE operations its better to use the InnoDB. InnoDB follows the [...]

Read More...

First of all I am big fan of the MooTools. I have started with MooTools very long ago and I am still learning new things every day from it. :) If you are aware of MooTools then you must have gone through below points, but if your starting with the MooTools then it will be [...]

Read More...

From the arrival of the smartphone we can say technology have found another creative way to share the data. QR Code is one of the method to share the data in very effective way. QR Code stands for “Quick Response code”. Now a days QR is widely used for sharing the data in easy and [...]

Read More...