iis php mysql php mysql Errcode: 28 The ultimate solution

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 the 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, and it will be solved after passing the first one. I will study the second one carefully in the future.

The above introduces the ultimate solution to iis php mysql php mysql Errcode: 28, including the content of iis php mysql. I hope it will be helpful to friends who are interested in PHP tutorials.