python sql mysql

Question

我有一个无法执行的 SQL 查询:是这样的:

select creation_time as date, abs(USD_amount) as amount 
from pending_transactions as p 
    inner join users as u 
           on u.user_id = p.user_id 
where (p.transaction_status = 'black' or p.transaction_status = 'green' or  
       p.transaction_status = 'gray) and u.referrer = 309 and
       creation_time > '0000-00-00 00:00:00' order by creation_time asc

我在Python中使用MySQLdb来访问DB，但它说这是错误的。如果有人可以帮助我使其工作，我将不胜感激。

Answer 1

这应该有效:

select creation_time as date, abs(USD_amount) as amount 
from pending_transactions as p 
    inner join users as u 
           on u.user_id = p.user_id 
where (p.transaction_status = 'black' or p.transaction_status = 'green' or  
       p.transaction_status = 'gray') and u.referrer = 309 and
       creation_time > '0000-00-00 00:00:00' order by creation_time asc

因为你忘记了一个'