Question - Is there any upper limit for the number of columns in a table?
Answer -
Although the exact size limitation depends on many factors, MySQL has a hard limit on max size to be 4096 columns. But as said, for a given table, the effective-maximum may be less.