Currently viewing the category: "stored procedure"

Stored Procedure For Finding Columns In MySQL

By On December 10, 2009 · 4 Comments

Looking for instances particular column in a large schema can be a pain. Fortunately the information schema makes this pretty easy, if your columns have a consistent naming convention.

SELECT table_schema, table_name, column_name FROM information_schema.columns WHERE column_name LIKE ‘%some_name%’;

Now, if we want to wrap this up into an easy to use stored [...]

Continue Reading →