**When I am creating new `field` after `198` columns, MySQL show below Error**

------------------**MySQL ERROR:**------------------

> 
> #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
> 
> 
> 

*Note*: I already changed datatypes `VARCHAR` -> to `TEXT` -> to `TINYTEXT`

I found many results for this Question in `StackOverflow`. Some people suggested to use `TEXT` instead of `VARCHAR`. But it works for upto `100` or `120` fields. Actually i need maximum `500` fields for my MySQL table.

------------------**My TABLE NAME : `dynamic_fields`**------------------

```
+----+---------+---------+---------+---------+
| id | field_1 | field_2 |  ....   |   ....  |
+----+---------+---------+---------+---------+
|  1 | NULL    | NULL    | NULL    |  NULL   |
+----+---------+---------+---------+---------+

```

I am adding fields to table `dynamic_fields` dynamically from **PHP** script.

Now `dynamic_fields` table have **198** fields with datatype `TINYTEXT`

------------------**SCENARIO:** for `dynamic_fields` fields------------------

Datatype `TINYTEXT` holds memory 256 bytes.  

Memory `256` bytes for every fields.  

Fields `198`.  

Total Memory : `256`\*`198` = 50688 bytes.

I need maximum `500` fields for `dynamic_fields`

**NOTE:** I am using `InnoDB` storage Engine for `MySQL`

How can I fix this error? Or is there any way to increase storage size for this problem?