MySQL CREATE table with > 4000 fields (with large sized colums) I wish to CREATE a table with 4000+ columns but an error happens.

Traceback (most recent call last):
  File "e:/OECD-Bot/src/csvTomysql.py", line 55, in &lt;module&gt;
    cursor.execute(creatQueryString)
  File "C:\Program Files\Python37\lib\site-packages\mysql\connector\cursor.py", line 551, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "C:\Program Files\Python37\lib\site-packages\mysql\connector\connection.py", line 490, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "C:\Program Files\Python37\lib\site-packages\mysql\connector\connection.py", line 395, in _handle_result
    raise errors.get_exception(packet)
mysql.connector.errors.DatabaseError: 1005 (HY000): Can't create table `csv_db`.`ear_mei` (errno: 185 "Too many columns")
4096 is the limit.

Innodb has a 1017 limit.

Reconsider your design.