Browsing Category

MySQL-Scripts

21 posts

MySQL related blog posts with scripts

Install exact version of Percona Server for MySQL on CentOS

Kedar
May 30, 2023

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…

View Post

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

Kedar
September 24, 2022

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…

View Post

MySQL function returns dates of specified day & between date range

Kedar
September 13, 2012

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…

View Post

Download MySQL’s Automatic Random Test Data Generator

Kedar
July 5, 2012

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…

View Post

MySQL Binary logs Generated Per Hour | Growth Estimate

Kedar
July 29, 2011

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…

View Post

MySQL Function to Convert Date To Words

Kedar
September 16, 2010

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…

View Post