This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…

The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.

In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe…

The post Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines first appeared on Change Is Inevitable.

This mysql stored function will return you all the dates between given dates having specified day. In short if you say: give me all Sundays in this month. I have…

The post MySQL function returns dates of specified day & between date range first appeared on Change Is Inevitable.

At times you’ll find yourself responsible for generating test data for newly created tables for testing or sampling purpose. There are tools that will generate random data for you but…

The post Download MySQL’s Automatic Random Test Data Generator first appeared on Change Is Inevitable.

The MySQL binary log is a set of log files that contain information about data modifications made to a MySQL server instance. At times we need to understand the disk…

The post MySQL Binary logs Generated Per Hour | Growth Estimate first appeared on Change Is Inevitable.

Recently I saw a MySQL Stored Function requirement on Experts-Exchange for converting date into some specific words format. You may find MySQL function for date to words conversion online; even…

The post MySQL Function to Convert Date To Words first appeared on Change Is Inevitable.

A lot of places I saw people asking for ways to generate Insert statements. We do have GUI Tool which can extract insert statements for us readily. Some of the…

The post How to generate Insert Statement in MySQL first appeared on Change Is Inevitable.

The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string. I…

The post MySQL Load Data Infile Syntax Generator Tool Download first appeared on Change Is Inevitable.

Assume we’ve a table with 100 rows and we need to select all columns but one.The problem is headache of actually typing out all 99 required columns!! In this blog…

The post Ideas for select all columns but one mysql stored procedure first appeared on Change Is Inevitable.

The Mysqldumpsplitter can extract database, table, all databases, all tables or tables matching on regular expression from a mysqldump. It can produce the compressed output of sqls in specified directories.…

The post MyDumpSplitter-Extract split database or tables from mysqldump | MySQLdump splitter first appeared on Change Is Inevitable.