MySQL Query Error [1114] 错误信息: The table 'C:\Windows\TEMP\#sql504_1219b6_4' is full SQL: SELECT [tablepre]_gooditems.subject AS subject1, [tablepre]_gooditems.subjectimage AS subjectimage1, [tablepre]_gooditems.itemid AS itemid1, [tablepre]_categories.*, [tablepre]_gooditems.*, [tablepre]_shopitems.* FROM [tablepre]_categories, [tablepre]_gooditems, [tablepre]_shopitems WHERE [tablepre]_gooditems.shopid = [tablepre]_shopitems.itemid AND [tablepre]_shopitems.region = [tablepre]_categories.catid AND [tablepre]_categories.upid=6 ORDER BY [tablepre]_gooditems.viewnum ASC LIMIT 4