Showing posts with label Row size too large. The maximum row size for the used table type. Show all posts
Showing posts with label Row size too large. The maximum row size for the used table type. Show all posts

Saturday, December 19, 2020

Mysql import table error : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

If you are facing this error while importing data in mysql, you need to edit the Engine type of your mysql table.

Error : Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

 Solution :

ALTER TABLE sheet4_5 ENGINE=MYISAM;