Introduction to SQLite 3 with example in Python

In this tutorial, we are going to see you how to establish the connection between SQLite 3 and python program and we also learn how to create a table through python programming.

Introduction to SQLite 3

An SQLite is a nothing but a database which has binding to several programming languages such as C, C++, Python, etc.

A simple program to create a table using SQLite in python.

before jump into the program, we have to install the  SQLite package. for installation flow the link:

click to know the installation process of SQLite

1st import the package :

#import the sqlite package to use all in built function of sqlite.
import sqlite3

now established the connection :

#established the coonection
connec=sqlite3.connect("student.db")
print("Database has been created  successfully......\n");

Create table STUDENTS:

#now create a table with name of students
connec.execute('''CREATE TABLE STUDENTS
         (ROLLNO          INT      ,
         NAME2           char(20)    ,
    
         ADDRESS2        CHAR(50)
         );''')
print("STUDENTS Table has been created successfully");

and at last closed the connection:

# closed the coonection.
connec.close()

The whole program single window:

#import the sqlite package to use all in built function of sqlite.
import sqlite3
#established the coonection
connec=sqlite3.connect("student.db")
print("Database has been created  successfully.....\n");
#now create a table with name of students
connec.execute('''CREATE TABLE STUDENTS
         (ROLLNO          INT      ,
         NAME2           char(20)  ,
    
         ADDRESS2        CHAR(50)
         );''')
print("STUDENTS Table has been created successfully");
# closed the coonection.
connec.close()

Output:

Database has been created  successfully
STUDENTS Table has been created successfully

Next part of this tutorial:

• python program to insert the value in table and show them using SQLite

Also, read:

• Insert multiple rows in MySQL table in Python
• UPDATE Data in MySQL Database table using Python