Breaking News: Grepper is joining You.com. Read the official announcement!

create sqlite database python

Add Answer

Xerothermic Xenomorph answered on April 21, 2021 Popularity 10/10 Helpfulness 7/10

answer create sqlite database python

related python create sqlite db file

related create sqlite table in python

create sqlite database python

Comment

import sqlite3

conn = sqlite3.connect('TestDB.db')  # You can create a new database by changing the name within the quotes
c = conn.cursor() # The database will be saved in the location where your 'py' file is saved

# Create table - CLIENTS
c.execute('''CREATE TABLE CLIENTS
             ([generated_id] INTEGER PRIMARY KEY,[Client_Name] text, [Country_ID] integer, [Date] date)''')
          
# Create table - COUNTRY
c.execute('''CREATE TABLE COUNTRY
             ([generated_id] INTEGER PRIMARY KEY,[Country_ID] integer, [Country_Name] text)''')
        
# Create table - DAILY_STATUS
c.execute('''CREATE TABLE DAILY_STATUS
             ([Client_Name] text, [Country_Name] text, [Date] date)''')
                 
conn.commit()

# Note that the syntax to create new tables should only be used once in the code (unless you dropped the table/s at the end of the code). 
# The [generated_id] column is used to set an auto-increment ID for each record
# When creating a new table, you can add both the field names as well as the field formats (e.g., Text)

Popularity 10/10 Helpfulness 7/10 Language python

Source: datatofish.com

Tags: database python sqlite

Link to this answer
Share Copy Link

Contributed on Apr 21 2021

Xerothermic Xenomorph

0 Answers Avg Quality 2/10

Closely Related Answers

python create sqlite db file

Comment

import sqlite3
from sqlite3 import Error


def create_connection(db_file):
    """ create a database connection to a SQLite database """
    conn = None
    try:
        conn = sqlite3.connect(db_file)
        print(sqlite3.version)
    except Error as e:
        print(e)
    finally:
        if conn:
            conn.close()


if __name__ == '__main__':
    create_connection(r"C:\sqlite\db\pythonsqlite.db")
Code language: Python (python)

Popularity 9/10 Helpfulness 3/10 Language python

Source: www.sqlitetutorial.net

Tags: file

Link to this answer
Share Copy Link

Contributed on Jan 09 2022

Doubtful Dotterel

0 Answers Avg Quality 2/10

create sqlite table in python

Comment

import sqlite3
# it will create a databse with name sqlite.db
connection= sqlite3.connect('sqlite.db')

Popularity 9/10 Helpfulness 2/10 Language python

Source: www.alixaprodev.com

Tags: python py

Link to this answer
Share Copy Link

Contributed on Apr 22 2022

Pythonist

0 Answers Avg Quality 2/10

create sqlite database python

Contents

More Related Answers

create sqlite database python

Closely Related Answers

python create sqlite db file

create sqlite table in python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.