[mysql] column 개수 확인하는 방법

SELECT COUNT(*) 
FROM information_schema.columns 
WHERE table_name=' 테이블명 ';

C# Example 

string query = "SELECT COUNT(*) FROM information_schema.columns WHERE table_name='" + dbname + "'";//column 개수 설정

 using (comm = new MySqlCommand(query, conn))

            {

                colCount = Convert.ToInt32(comm.ExecuteScalar());

                setMaxRowIndex(colCount);//column 개수설정

            }