php mysql Errcode: 28 Ultimate Solution_PHP Tutorial

perror 28
Error code 28: No space left on device

SQL statement execution error: SELECT title,gid FROM blog_blog WHERE date < 1246200383 and hide = 'n' and type='blog' ORDER BY date DESC LIMIT 1
Error writing file 'C:WINDOWSTEMPMY9B6F.tmp' (Errcode: 28)

Solution:

1. Release C:WINDOWSTEMP space

2. Because the original table is too large, the temporary table generated during the query is too large, so an error occurs.
Solution. I restarted mysql, and then added where to query in three sections to avoid a full table scan.

Test results: The first one is useful, the second one makes sense, I haven’t tested it yet, it will be solved after passing the first one, I will study the second one carefully in the future