Problems with SQL and Python to extract values

Question

I have a problem when i extract values from a DB with sqlite3. Everytime that i extract values ,for example, one number have this format:

[(6,)]

And is like tuple. I want only the 6 value WITHOUT , and ( and [

Thanks for your help in advanced!

This is common in scenerio when adapter do not know either number of rows or number of columns to output. I am pretty sure it return a value when we fetch max() of the column in which it knows that there will be only value to output. — mad_
– mad_, Commented May 11, 2018 at 14:49

eatmeimadanish · Accepted Answer · 2018-05-11 14:28:17Z

1

This is common in all SQL adapters. They always return a list of rows (tuples) even if you only fetchone, it comes back with a tuple, because it doesn't know if this is one value, or one row of values, so to stay constant... tuple.

x[0] is your first row x[0][0] is your first item in that row.

answered May 11, 2018 at 14:28

eatmeimadanish

3,9231 gold badge16 silver badges21 bronze badges

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

1 Comment

Carlos Roca Pin Over a year ago

Thanks a lot to all people. An special to eatmeimadinish for the clear explanation.

Collectives™ on Stack Overflow

Problems with SQL and Python to extract values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related