In [1]:

    

import MySQLdb


    

In [2]:

    

db = MySQLdb.connect(host="localhost", user="root", db = "amazon_reviews")


    

In [3]:

    

cursor = db.cursor()


    

In [5]:

    

cursor.execute("SELECT DISTINCT PID FROM mult_reviews_test WHERE RUserID = " + '"A2089H8OF82RH4"')


    

    
Out[5]:





7L

In [6]:

    

print cursor.fetchall()


    

    




((' B00023DDRM',), (' B00023DDSG',), (' B00023DDSQ',), (' B00023DDS6',), (' B00023DDTU',), (' B00023DDTA',), (' B000ANLXG2',))

In [7]:

    

cursor.execute("SELECT DISTINCT PID FROM mult_reviews_test WHERE RUserID = " + '"AX4VWMTFHQE4R"')


    

    
Out[7]:





6L

In [8]:

    

print cursor.fetchall()


    

    




((' B00023DDRM',), (' B00023DDSG',), (' B00023DDSQ',), (' B00023DDS6',), (' B00023DDTU',), (' B00023DDTA',))

In [ ]: