How can I select a column with no values?

Posted by Lye on Stack Overflow See other posts from Stack Overflow or by Lye
Published on 2010-04-09T20:06:16Z Indexed on 2010/04/09 20:13 UTC
Read the original article Hit count: 214

Filed under:

I have a table with thousands of rows and hundreds of columns (not my design). I'm trying to find out which columns are never used so I can simplify the table a little. How can I find which of the columns have no value in all rows?

© Stack Overflow or respective owner

Related posts about mysql