PHP mysql errcode:28 Ultimate Solution _php Tips

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= ' blogs ' ORDER by date DESC LIM IT 1
Error writing file ' C:\WINDOWS\TEMP\MY9B6F.tmp ' (errcode:28)

Workaround:

1. Free C:\WINDOWS\TEMP\ Space

2. Because the original table is too large, the temporary table generated at the query is too large to make an error.
Solutions. Restart MySQL, then add a where to the three-paragraph query to avoid full table scans.

Test results: The first useful, the second reasonable, not tested, after the first solution, the second after a good study