ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn;
I used 300 for my AVG_ROW_LENGTH because I calculated my average to be about 260 bytes/row. YMMV
*WARNING* if you are doing this because the table is too big.. THIS WILL TAKE A LONG TIME.. COULD BE HOURS. during this time you will be able to query the table, but *NOT* update records.
Replys:
Import spreadsheet (csv) data into mysql database (Russell)
Add comment or question...:
This file (the script that presented the data, not the data itself) , last modified Tuesday 06th of March 2018 11:41:12 PM
your client: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
current time: Friday 26th of April 2024 03:09:52 AM