Python SQLite3 Tutorial 3 Insering Records Into the Database

Показать описание

Hello Everyone my name is Lenny from codewithlennylen254. In this video i'll show you how to start adding data to our database file. Pretty cool stuff to learn.Hope you enjoy.

Links for all the code for this series:

DB Browser for sqlite:

Рекомендации по теме

Комментарии

first channel i have watched who dont have any ads.

avihk

Thanks. But what if I want to populate the tables fields from a Python (string) list instead of INSERTing them as static strings in quotation marks? On my Pi, in Python, I can't use variables in place of the literal string in the insert statement. Like this. (Assume indents are correct)

import sqlite3

namelist=["Jack", "Charlie", "Ann"]
conn=sqlite3.connect ("data.db")
curs=conn.cursor ()
curs.execute ("""CREATE TABLE IF NOT EXISTS NAMETABLE(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL)""")
# then after commiting ...

n=1
for nm in namelist:
curs.execute ("INSERT INTO NAMETABLE(ID, NAME) VALUES (n, nm)
n+=1

Why won't this work?

jackburnell

Python SQLite3 Tutorial 3 Insering Records Into the Database

Python SQLite3 Tutorial 3 Insering Records Into the Database

Sqlite 3 Python Tutorial in 5 minutes - Creating Database, Tables and Querying [2020]

Python SQLite Tutorial: Complete Overview - Creating a Database, Table, and Running Queries

SQLite in Python || Python Tutorial || Learn Python Programming

Customtkinter and SQLite with Python Lesson 3 - Insert Into Table

Python SQLite3 Tutorial 3 - SELECT (view) items in tables

SQLite Databases With Python - Full Course

Python SQLite #3: команды SELECT и INSERT при работе с таблицами БД

Python Programming - Python SQLite T03 - Insert, Update, Delete Row (Part 1/3)

Python SQLite3 tutorial in One Video | yusy4code

#5 Python SQLite3 - How to Insert Data in Sqlite3 DatabaseTable

Python Sqlite3 Tutorial Beginners

SQLite Backend for Beginners - Create Quick Databases with Python and SQL

SQLite & Python - 3 - Insert Into Table

Python Basics Tutorial Sqlite Working With Two Tables

Python SQLite3 Tutorial 4 Using Variables to Insert Data

Creating a database, table, and inserting - SQLite3 with Python 3 part 1

SQLite databases with python | Add variables to a table | Tutorial 3

How to store data with Python and SQLite3

Python SQLite3 Tutorial 2 Creating a Table

Inserting variables to database table - SQLite3 with Python 3 part 2

Python SQLite3 Basics Tutorial

Python Programming - Python SQLite T03 - Insert, Update, Delete Row (Part 2/3)

Python SQLite3 Tutorial 2 - How to insert into tables ( add items)