Open the command line, navigate to the directory where MySQL is installed. Further, navigate to the directory 'bin' inside the MySQL directory (in my case, the directory structure is C:\mysql\bin> ) and open MySQL console by entering following command.

Open the command line, navigate to the directory where MySQL is installed. Further, navigate to the directory 'bin' inside the MySQL directory and enter the following command to take the dump of a MySQL database.

If you need to develop applications (say for online tests) where you want the questions to appear on a random order every time a new test is taken, this MySQL query may prove helpful.

You may have encountered a situation when you wanted to insert data with single quotes (') into your database and it trigerred a query error. This usually occurs when our SQL statement contains single quotes in the data that are not escaped.

Special characters such as single quotes need to be escaped in string values of an SQL statement. Normally, the php function addslashes does the job of escaping all such special characters.