connecting to mysql database using python script

Question

Hey guys just a small question on this connection here. I wanted to print the output of the sql db using python which is currently successful but the output is not what i desired.

def query(conn):
    x = conn.cursor()
    x.execute ("SELECT Amount from Expenses")
for item in x.fetchall():
    items = map(int,item)
    print "The amount is %s" % (items)

output: The amount is [15000] --> which is the concern here. I want to get rid of the square brackets in the output. Please help me out on this

@BhargavMg items is a list "[]" these brackets in python means it's a list. In rakesh's comment he's trying to access the first element from the list. — Strik3r
– Strik3r, Commented May 30, 2018 at 6:10

burning · Accepted Answer · 2018-05-30 05:59:28Z

1

The response you are getting if for items which can be multiple and it return a list.

So you are getting [15000]

How can i get rid of square bracket.

simple items[0]

If you are expecting multiple value and want to get all just simple iterate over a loop.

for item in items:
    print item

answered May 30, 2018 at 5:59

burning

2,5966 gold badges26 silver badges41 bronze badges

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

Comments

Rakesh · Accepted Answer · 2018-05-30 06:07:46Z

0

fetchall return you a list of tuples. You do not need map also. You can directly access the element using index.

Ex:

def query(conn):
    x = conn.cursor()
    x.execute ("SELECT Amount from Expenses")
    for item in x.fetchall():
        #items = int(item[0]) -->Use index to access the element. 
        print "The amount is %s" % (item[0])

answered May 30, 2018 at 6:07

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

2 Comments

Bhargav Mg Over a year ago

Hi Rakesh thanx for the help, much appreciated. I actually used map since the int value was being appended with a long extension 15000L. Hence i used it to convert the value to a plain int. Can you please help me understand how even after removing that map command too the L is not appended to the output.

Rakesh Over a year ago

Because L is just a representation for "Long".

Collectives™ on Stack Overflow

connecting to mysql database using python script

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related