Store SQLite 3 Data as a Variable in Python

Question

Is it possible for me to take data stored in a sqlite3 table and use it as a Python variable? I'm looking for something that might be similar to this pseudo-code:

import sqlite3
conn = sqlite3.connect(DATABASE)
cursor = conn.cursor()
variable = cursor.execute("fetch data from table")

Why can't you just do a SELECT?

CL.
– CL.

2014-03-30 20:39:25 +00:00
Commented Mar 30, 2014 at 20:39 — CL.
– CL., Commented Mar 30, 2014 at 20:39
@CL. I wanted to take a specific column from the table

HarryMoy
– HarryMoy

2014-04-01 07:00:06 +00:00
Commented Apr 1, 2014 at 7:00 — HarryMoy
– HarryMoy, Commented Apr 1, 2014 at 7:00

CL. · Accepted Answer · 2014-04-01 07:28:21Z

3

To read a single value from a table, use a SELECT query that returns a result with a single row and a single column:

for row in cursor.execute("SELECT MyColumn FROM MyTable WHERE ID = ?", [123]):
    variable = row[0]
    break
else:
    variable = 0  # not found

answered Apr 1, 2014 at 7:28

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Comments

General Grievance · Accepted Answer · 2023-09-14 14:14:31Z

-2

Use something like this:

SELECT COUNT(*) FROM table_name

edited Sep 14, 2023 at 14:14

General Grievance

5,12039 gold badges39 silver badges60 bronze badges

answered Sep 10, 2023 at 4:13

Ridit Chauhan

12 bronze badges

1 Comment

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Store SQLite 3 Data as a Variable in Python

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related