Skip to content

Instantly share code, notes, and snippets.

@chales
chales / mysql-search.sql
Last active July 24, 2018 17:39
Procedure to search through all databases, tables and columns in MySQL DB Server.
# Search through all databases, tables, and columns in a MySQL db.
# From http://kedar.nitty-witty.com/blog/search-through-all-databases-tables-columns-in-mysql
## Table for storing resultant output
CREATE TABLE `temp_details` (
`t_schema` varchar(45) NOT NULL,
`t_table` varchar(45) NOT NULL,
`t_field` varchar(45) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;