How to generate Insert Statement in MySQL
Kedar
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…
Browsing Category
MySQL-Scripts
21 posts
MySQL related blog posts with scripts
MySQL Load Data Infile Syntax Generator Tool Download
MySQL LOAD DATA INFILE is a common command used to load delimited data to MySQL database. Here’s a tool to generate the Syntax for MySQL’s LOAD DATA INFILE command. I…
Ideas for select all columns but one mysql stored procedure
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…
MyDumpSplitter-Extract split database or tables from mysqldump
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.…
How to bulk rename table MySQL
Are you tired of manually renaming MySQL tables, one by one, especially when dealing with a large number of them? In this guide, we’ll introduce you to a MySQL stored…
Stored procedure to Find database objects
This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…