Ow The size too large. The maximum row size for The 2 table type, not counting BLOBs, is 65535.
Through research, found that is more than the SQL data volume is too big to accept the total number of characters, further explored, found if the system default is to import the data size in bytes of each column is 255, as shown in the figure below:
So I try to change the byte length, the final data can be smooth import, but because there are more than one hundred listed so I change a lot of pain,
I would like to ask the question is:
If there are 500 or 1000 column import data, how to amend the string length of 255 batch instead of each point in modification,
Thank you very much!
PS: about whether to import the data use UTF8 format may import failure problems after I check information has been solved, so I don't need to consider this problem,