在几个值之后，第1行的列截断了1265个数据

Question

hello i am trying to add data to mysql column but after some data has been input it throws subject mentioned error

The structure is

the column data format is

Answer 1

Your data is being truncated because it exceeds the 255 byte limit of a tinytext column. You'll need to use a column type that supports more data:

      Type | Maximum length
-----------+-------------------------------------
  TINYTEXT |           255 (2 8−1) bytes
      TEXT |        65,535 (216−1) bytes = 64 KiB
MEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MiB
  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GiB

(from TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes)