Inserting data into MySQL
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!