Inserting data into MySQL
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!