Many programmers using php to connect to mysql face this error while writing/testing their code.
Fatal error: Uncaught Error: Call to undefined function mysql_connect()
Many websites and tutorials contains sample code containing mysql_connect which no longer works. This article provides details on why and what to do to fix this error.
Many times, we need to figure out if there is a duplicate in a particular column of a database. Here is a quick guide on how to find duplicates in a column in MySql.
Many times one want to join 2 columns in a MySql table. For example, you have saved 'First Name' and 'last name' in separate columns and now want to get 'Full Name' as part of query output.
MySql supports the concept of sql modes which are global configuration for every sql command. Sometimes one needs to remove particular sql mode like ONLY_FULL_GROUP_BY. Here is a quick guide about how to disable sql modes.
MySql remains one of the most popular database around and it has maintained its popularity even in the age of large number of nosql databases. It remains one of the easiest database to use and at the same time it is stable enough to host successful comapnies (for example, companies like uber, facebook, yahoo all use MySql for many of their use cases)