Error: 1017 Can’t find file! (errno: 2)
mysql> REPAIR TABLE database.postmeta USE_FRM;
Category: MySQL
Insert/ Update random date in MySQL
UPDATE mytable SET col = CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14) DAY
Error: 1017 Can’t find file! (errno: 2)
mysql> REPAIR TABLE database.postmeta USE_FRM;
UPDATE mytable SET col = CURRENT_TIMESTAMP - INTERVAL FLOOR(RAND() * 14) DAY