finding column names in large tables
everyone knows that you can dump all the column attrs out with a describe <tablename> query. let's say there is a large table and you have an idea of the column name...
SHOW columns in <tablename> like 'searchterm'Same thing for table names
SHOW tables in <database> like 'searchterm'wildcards (%) can help you narrow your results down.
Written by Matt Frost
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mysql
Authors
Related Tags
#mysql
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#