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

MySQL Stored procedure to Generate-Extract Insert Statement

Kedar
May 5, 2010

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

View Post

MySQL Load Data Infile Syntax Generator Tool Download

Kedar
April 8, 2010

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…

View Post

Ideas for select all columns but one mysql stored procedure

Kedar
March 5, 2010

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…

View Post

MyDumpSplitter-Extract split database or tables from mysqldump | MySQL dump splitter

Kedar
February 11, 2010

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.…

View Post

MySQL-Scripts

Install exact version of Percona Server for MySQL on CentOS

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

MySQL function returns dates of specified day & between date range

Download MySQL’s Automatic Random Test Data Generator

MySQL Binary logs Generated Per Hour | Growth Estimate

MySQL Function to Convert Date To Words

MySQL Stored procedure to Generate-Extract Insert Statement

MySQL Load Data Infile Syntax Generator Tool Download

Ideas for select all columns but one mysql stored procedure

MyDumpSplitter-Extract split database or tables from mysqldump | MySQL dump splitter

Recent Posts

Recent Comments