IIS php mysql php mysql errcode:28 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 LIM IT 1
Error writing file ' C:\WINDOWS\TEMP\MY9B6F.tmp ' (errcode:28)
Workaround:
1. Releasing C:\WINDOWS\TEMP\ space
2. Because the original table is too large, the temporary table generated at the time of the query is too large to make an error.
Solution. Restart MySQL, and then add where to the three-segment query to avoid full-table scanning.
Test results: The first useful, the second makes sense, not tested, after the first to solve the second after a good study

The above describes the IIS php mysql php mysql errcode:28 ultimate solution, including the IIS php MySQL content, I hope to be interested in PHP tutorial friends helpful.

