Stored procedure to Find database objects

Kedar
December 5, 2009

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

View Post

MySQL Stored procedure – Split Delimited string into Rows

Kedar
December 5, 2009

This procedure will split a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And…

View Post

MySQL Stored procedure – Execute query if table or Column exists

Kedar
December 5, 2009

Well procedures mainly carried out working with information schema and it’s usage in stored procedure. Procedures are fairly simple and easy to understand. 1. Edit_table – following procedure executes queries to…

View Post

Calculate MySQL Memory Usage – Quick Stored Procedure

Kedar
November 16, 2009

In this post we will look into the MySQL memory utilization estimation or calculation based on the global variables. Using a simple stored procedure call you can get the memory…

View Post

how to search / find through all databases, tables, columns in MySQL

Kedar
October 29, 2009

What will you do if one day some one ask you to find single string in all databases, all tables and in all columns, In MySQL Database? This article presents a practical solution…

View Post