Skip to content

Pythoneo

Online How to Python stuff

How to connect to database and print the sum of costs using sqlite3 module?

Posted on December 16, 2020July 4, 2022 By Luke K

Here’s how to prepare a simple SQL query using sqlite3 module. The code is following:

Sum of costs query

import sqlite3
 
connection = sqlite3.connect("my.db")
cursor = connection.cursor()
c = conn.cursor()
c.execute('SELECT SUM(cost) FROM deals WHERE id= "123"')
print(c)

The output of above query is the sum of cost from the table “deals” for id = “123”. With such example I’m sure you would be able to adjust the query for your needs.

sqlite3 Tags:database, query, SQL

Post navigation

Previous Post: How to check status of the website?
Next Post: Calculate age from date of birth in Python

Categories

  • bokeh (1)
  • datetime (3)
  • Django (5)
  • glob (1)
  • io (1)
  • json (1)
  • math (5)
  • matplotlib (10)
  • numpy (100)
  • OpenCV (1)
  • os (3)
  • Pandas (3)
  • paramiko (1)
  • pathlib (2)
  • Pillow (3)
  • Plotly (3)
  • Python (31)
  • random (7)
  • requests (1)
  • Scipy (4)
  • Seaborn (7)
  • shutil (1)
  • sqlite3 (1)
  • statistics (16)
  • sys (1)
  • Tkinter (9)
  • turtle (2)
  • Uncategorized (1)
  • urllib (1)
  • webbrowser (1)

RSS RSS

  • How to use random seed in Numpy
  • TypeError: ufunc ‘add’ did not contain a loop with signature matching types
  • How to resolve AttributeError: ‘numpy.ndarray’ object has no attribute ‘function_name
  • How to resolve TypeError: Cannot perform reduce with flexible type
  • How to resolve ValueError: operands could not be broadcast together with shapes (X,) (Y,)
  • How to resolve ValueError: operands could not be broadcast together with shapes
  • How To Remove n From String In Python?
  • How To Exit A Function In Python
  • How to create violin plot using seaborn?
  • How To Use Colormaps In Matplotlib?

Tags

arithmetic mean array axis button calculations chart conversion copy count counter data type dictionary dimension draw error files fill float generate grid GUI image index integer list matrix max mean median min normal distribution plot random reshape rotate round size standard deviation string sum test text time variance zero

Copyright © 2023 Pythoneo.

Powered by PressBook WordPress theme

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT