Convert sql output to string in python

Question

I am quite new to coding (I actually started 3 days ago), so please bare with me in case this question is easy to solve.

Here is my problem:

I connected myself to my db and requested data from db using mysql.connector in PyCharm
I want the result to be a plain string and assign this "plain" data to a variable so I can use it later in my code
I do get the result in a different way (is it a list?)

So here is my code:

mycursor = mydb.cursor()

mycursor.execute("select firstname from customer c join application a on a.customerid = c.id where c.id=1;")
firstname = mycursor.fetchall()

print(firstname)

My current output:

[('Max',)]

My expected output:

Max

Any ideas how I can convert firstname to my desired format?

Thanks in advance!

hi, perhaps get the first row with fetchone and then get the first column with row[0] — IronMan
– IronMan, Commented Jan 4, 2021 at 19:54
thanks for the answer, I only get one value (=firstname), I was wondering how I can remove these characters right and left [('',)] — Anon 0815
– Anon 0815, Commented Jan 4, 2021 at 19:57

Ted Brownlow · Accepted Answer · 2021-01-04 20:18:34Z

1

If you only need a single row, use mycursor.fetchone() instead of mycursor.fetchall().

The result you're currently getting is a list containing 1 tuple containining 1 string. It can be accessed as firstname = mycursor.fetchall()[0][0]

The better solution is firstname = mycursor.fetchone()[0]

answered Jan 4, 2021 at 20:18

Ted Brownlow

1,1249 silver badges16 bronze badges

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

1 Comment

Anon 0815 Over a year ago

Thanks, also for the explanation. Will do some research on this "tuple" thingy.

Emiliano R. · Accepted Answer · 2021-01-05 19:47:47Z

0

mycursor = mydb.cursor() Var1 =[] mycursor.execute("select firstname from customer c join application a on a.customerid = c.id where c.id=1;") firstname = mycursor.fetchall() for nameList in firstname:

  nameList.append(firstname)

print(nameList)

Try this...

answered Jan 5, 2021 at 19:47

Emiliano R.

111 bronze badge

Collectives™ on Stack Overflow

Convert sql output to string in python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related