Inserting data into MySQL
3 次查看(过去 30 天)
显示 更早的评论
Hello, i am currently getting the following error:
??? Error using ==> database.insert at 178 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
i currently am using this bit of code to insert the data:
insert(conn, 'Sample', colnames, sample2);
Sample 2 contains 150 columns of data with each column data being a string of information of ~ 190-200 characters long.
initally my MySQL table datatype was varchar(250), i have changed this to text, longtext, blob, longblob....i have changed the row_format to dynamic or compressed for each datatype i have tried but still no luck.
can someone help, and know away around it please.
Thank you in advance
0 个评论
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!