C and Python Applications: Embedding Python Code in C Programs, SQL Methods, and Python Sockets

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022

P. JoyceC and Python Applications https://doi.org/10.1007/978-1-4842-7774-4_4

4. SQL in Python

Philip Joyce¹  

(1)

Crewe, UK

 

This chapter introduces the reader to the way the database language, “Structured Query Language,” can be accessed and used from a Python program. It will be demonstrated how to create the database file. When this is done, the reader will be able to create database tables. Then, it will be shown how to insert data into the table, how to amend data in the table, how to delete data from the table, and how to print out data held in the table.

Review of SQL

SQL (Structured Query Language) is used to access a database. The easiest way to understand ...