Python Sqlite3 Tutorial Beginners

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

Here are my social platforms:
Рекомендации по теме
Комментарии
Автор

The clearest tutorial on sqlite3 I've seen so far. Thanks.

timothybloxsome
Автор

First SQLite tutorial to actually explain what the code does and why you use it.
Thanks Jayanam

sulaimanamjad
Автор

Thanks for the tutorial. Just for your information, if you upload another video to YouTube, it is very difficult to see your screen. Inverting to a white background is better.

philwilkinson
Автор

Do i have to download sqllite? I have a windows pc and i use enthought canopy for python. All i did was >>> import sqlite3 and it worked. Is this fine?

abe_ok
Автор

With regards to editing the path variable - whats the consequences if the path is already set at something else?
Mine shows for example...

kevmscotland
Автор

Ty for tutor can i ask how to edit the database? with sqlite3

farrasatsany
Автор

Hello good afternoon, I need help with the code of this program:
import sqlite3
def insertar():

print("Estas en la funcion insertar")

nombre1=raw_input("Escribe el titulo de la novela ")
autor1=raw_input("Escribe el autor de la novela ")
year1=str(input("Digita el anio de la novela "))

consulta=db1.cursor()

strConsulta = "insert into tabla(nombre, autor, year) values ("+nombre1+", "+autor1+", "+year1+")"
print(strConsulta)


consulta.close()
db1.commit()
db1.close()
insertar()
When running, it works but then I get this error:
Traceback (most recent call last):
File capacitate para el empleo/Programador (orientado a objetos)/Nivel 2/ejercicios python/Ejemplos/ejemploDB.py", line 19, in <module>
insertar()
File capacitate para el empleo/Programador (orientado a objetos)/Nivel 2/ejercicios python/Ejemplos/ejemploDB.py", line 15, in insertar

sqlite3.OperationalError: near "Abreu": syntax error


Please tell me what I am failing with the code or why this error is due and how to correct it.
Regards

juanbanoscaro