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: 211
mysql
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