Python中ORDER BY的位置

Question

我在哪里把ORDER BYweight_record.date在这个语句到fetchall()到一个数组排序的最早日期到最近?

mycursor.execute(
"SELECT weight_record.date AS wr_date, 
weight_record.weight AS wr_weight, 
calorie_record.calories AS cr_calories 
FROM weight_record 
JOIN calorie_record ON weight_record.date = calorie_record.date 
WHERE weight_record.username = %s 
AND calorie_record.username = %s", (user, user))

谢谢。

Answer 1

从文档来看，ORDER BY应该在WHERE条款之后。