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

14 responses to “how to search / find through all databases, tables, columns in MySQL”

Find and Replace text in all table using mysql query
November 8, 2022
[…] Now, as you talk of replace in all tables, that’s something not possible in single query. Though you can create a routine to do so! For the sample you can refer a procedure which is finding a string in all tables of all databases. […]