12 STEPS to SQLite3 in Python
Demoing SQLite3 in Python in under a minute
Outline:
Connect to DB (file)
Get a cursor
Create a TABLE in the DB file
Insert a single record
Save the changes with commit
Get the records
Understanding fetchall
saving fetchall into a List variable
Here are all the commands for your reference:
import sqlite3
conn = sqlite3.connect("mydb.db")
crsr = conn.cursor()
crsr.execute("""
CREATE TABLE users(
id INTEGER PRIMARY KEY AUTOINCREMENT,
user TEXT NOT NULL);
""")
crsr.execute("""
INSERT INTO users ( user ) VALUES ( "JOE" )
""")
conn.commit()
crsr.execute("SELECT * FROM users;")
crsr.fetchall()
crsr.fetchall()
crsr.execute("SELECT * FROM users;")
result = crsr.fetchall()
result
Видео 12 STEPS to SQLite3 in Python канала Life on Linux
Outline:
Connect to DB (file)
Get a cursor
Create a TABLE in the DB file
Insert a single record
Save the changes with commit
Get the records
Understanding fetchall
saving fetchall into a List variable
Here are all the commands for your reference:
import sqlite3
conn = sqlite3.connect("mydb.db")
crsr = conn.cursor()
crsr.execute("""
CREATE TABLE users(
id INTEGER PRIMARY KEY AUTOINCREMENT,
user TEXT NOT NULL);
""")
crsr.execute("""
INSERT INTO users ( user ) VALUES ( "JOE" )
""")
conn.commit()
crsr.execute("SELECT * FROM users;")
crsr.fetchall()
crsr.fetchall()
crsr.execute("SELECT * FROM users;")
result = crsr.fetchall()
result
Видео 12 STEPS to SQLite3 in Python канала Life on Linux
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
OpenShotQt 2.4.4 Tutorial - Create Custom Title TemplateMake your LinuxMint a little like a MACWordPress Installation Tutorial - Absolute BeginnerFullstack on Android? Using Termux #shortsNo more STRANGE ADS on ROKU!LifeOnLinux LibreOffice Transpose a Data TableChatGPT makes - PineWood Race Heat GeneratorAtom Text Editor - Download and InstallMake Android APPS on your Android PHONE !fail2ban MORE TIME bantimeMySQL Server - Use Workbench 6.3 to Create a new UserHow to create a Database on MySQL server, using the command line.Console "GUI" App with PythonBeginner File Operations in ONE MinuteDocker GUI Portainer - First LookLinux Ubuntu Server, UFW Starter Tutorial, A quick look at UFW - Beginners QuickstartMySQL Workbench 6.3 - Schema Transfer WizardAndroid Automation Opensource and PrivateBeginner "Tutorial" on Python List ComprehensionDon't USE Python, BE Python with bpython interactive shell.