SQL Tutorial for beginners: (2) INSERT, UPDATE and DELETE records in a table using SQLite3

preview_player
Показать описание
In this video, we will learn how to insert, update and delete records in a table using SQLite3 module in Python programming language.

The sqlite3 module was written by Gerhard Häring. It provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249. You can also supply the special name :memory: to create a database in RAM. Usually your SQL operations will need to use values from Python variables.

Video Contents💡
00:00 Review for last video [ CREATE TABLE and Fetch data]
04:23 UPDATE Record
08:50 INSERT Record
11:35 DELETE Record

Рекомендации по теме
Комментарии
Автор

Brilliant stuff, short clear and to the point

petitboucle
Автор

Thank you.. as I will always say.
I appreciate your effort. 👍

leomacdon
Автор

How do update and delete using the user input please

ashleighseldon
Автор

I'm getting this error. Please help me out!
c.execute(sql_command)
Attribute Error: object attribute "execute" is read-only.

sumbulk.