Wednesday, September 15, 2010

How to find all the tables in MySQL with specific column names in them?


select  table_schema, table_name, column_name
from INFORMATION_SCHEMA.COLUMNS
where column_name like 'FraUrgente';

No comments:

Post a Comment

xfce4-screenshooter keyboard shortcut

sh -c 'xfce4-screenshooter --fullscreen --save "$HOME/Pictures/Screenshots/Screenshot_$(date +%Y-%m-%d_%H:%M:%S).png"' s...