MySQL Prepared Statements

Prepared statements are the ability to set up a statement once, and then execute it many times with different parameters. …

Changing MySql User Password

The mysqladmin tool can be used for changing MySql user’s password. The following line of code will change the user1′s …

If we lost the root privilege or password, it can be retrieved by the following steps :
Stopping MySQL :
Shell Command
/etc/init.d/mysqld …

This can be done by using both insert and select queries.
Example :
Suppose we have two tables student and mark :
Student
id …

PDO(PHP Data Objects) is one of main feature of PHP 5.1 to managing databases. It is developed to provide a …