python sql mysql

Question

I've got an SQL query which I can not make work: it's like this:

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

I use MySQLdb in Python to access a DB but it says that it's wrong. If anyone could help me to make it work it would be so much appreciated.

score 1 · Accepted Answer · 2014-11-22 22:38:49Z

1

THis should work:

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

Because you forgot one '

edited Nov 22, 2014 at 22:38

answered Nov 22, 2014 at 22:33

user3522371

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

python sql mysql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related