Re: Got error 64 when reading table '/tmp/#sql_5389_0'

[Rick James]

Why use a subquery? Won't this work?

SELECT  `stuffA`, `stuffB`, `tID`,
        STR_TO_DATE(`Submit Date_Time`, '%d-%M-%Y') AS 'mydate'
    FROM  my.database t
    WHERE  `cID` = '123456'
      AND  `stuffA` = 1
    WHERE  mydate <= '2012-03-01'
    ORDER BY mydate DESC

(Blanks in column names is asking for trouble.)