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

python sql3 how to add data synmically

Arvind Kumar answered on July 6, 2023 Popularity 1/10 Helpfulness 1/10

answer python sql3 how to add data synmically

python sql3 how to add data synmically

Comment

import sqlite3
conn = sqlite3.connect('tutorial.db')
c = conn.cursor()


def create_table():
    c.execute("CREATE TABLE IF NOT EXISTS example(Language VARCHAR, Version REAL, Skill TEXT)") #<<<<<<<<<< CHANGED


def enter_data():
    c.execute("INSERT INTO example VALUES('Python', 2.7, 'Beginner')")


create_table() #<<<<<<<<<< ADDED
enter_data() #<<<<<<<<<< ADDED
c.execute("INSERT INTO example VALUES('Python', 3.3, 'Intermediate')")
c.execute("INSERT INTO example VALUES('Python', 3.4, 'Expert')")
conn.commit()


def enter_dynamic_data():
    lang = input("What language? ")
    version = float(input("What version? "))
    skill = input("What skill level? ")
    c.execute("INSERT INTO example (Language, Version, Skill) VALUES (?, ?, ?)",
          (lang, version, skill))
    conn.commit()
enter_dynamic_data()

cursor = c.connection.cursor() #<<<<<<<<<< ADDED
cursor.execute("SELECT * FROM example") #<<<<<<<<<< ADDED
for row in cursor: #<<<<<<<<<< ADDED
    print("Language=", row[0], " Version=", row[1], " Skill=", row[2]) #<<<<<<<<<< ADDED

conn.close()

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: add python sql

Link to this answer
Share Copy Link

Contributed on Jul 06 2023

Arvind Kumar

0 Answers Avg Quality 2/10

python sql3 how to add data synmically

Contents

More Related Answers

python sql3 how to add data synmically

Grepper

Documentation

Social

Legal

Contact

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