我得到了我在phpmyadmin上执行的代码，它100%有效CreateTemporaryTableSearches(idint,dtdatetime);CreateTemporaryTableSearches1(idint,dtdatetime,countint);insertintoSearches(id,dt)selecta.id,now()fromtblSavedSearchesa;insertintoSearches1(id,dt,count)selectb.savedSearchesId,(selectc.dtfromtblSavedSearchesDetailscwher