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

19 comments

How To Generate Random test Data In MySQL

Kedar
July 5, 2012

Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…

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