The default path on which the MySQL starts is service is different from the one defined in PHP. There are two ways to correct it, read more..
how you can rest a lost MySQL password. Using this procedure you can reset the lost password of root or any other MySQL user. The best part is, it only resets the password, keeping your tables and data inside them quite safe.
MySQL: Increment or Decrement an existing record in the table.
Undoubtedly a Web Application’s backbone is a database. Apparently, the Web Application’s performance is dependent on the database’s overall performance. However, some developers blame Database Administrators for non-performing of the web application to the end user.
MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when creating a new table. The major differences between these two storage engines are : InnoDB supports transactions which is not supported by tables which use
Learn how to enable query cache in MySQL and how it helps to improve performance.
Install MySQL Server 5 on Ubuntu and adding support to PHP
What is Memory(heap) Storage engine in MySQL ? Why should we use it and what are the pros/cons of using Memory Storage engine.
How to transfer mysql database using mysql command line.
Difference between Truncate and delete command in MySQL
Hey Guys, Let me first explain you the scenario in which more likely you can use this type of query. A generic scenario would be that you are inserting data into a table and along with this you want to update a counter which is nothing but a field in
Hi all, During my starting phase of career, i faced several challenging questions (being a fresher at that time). I wanted to share this one as simple as pie but can be difficult at times if you do not know how to do it. Question can be : How can