SQLite Databases With Python - Full Course
video description
Date: 2022-03-14
Related videos
Comments and reviews: 10
Vinay
File -e:\binu\c source\Python source\File I\sQLITEPRAC\our.py-, line 34, in delete_one-
c.execute(-DELETE FROM our WHERE rowid = (?)-,id)-
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.-
PS E:\binu\c source\Python source>
IM Facing This error
Function code is:-
def delete_one(id):-
conn = sqlite3.connect('datcustomer.db')-
c=conn.cursor()-
c.execute(-DELETE FROM our WHERE rowid = (?)-,id) -
conn.commit()-
conn.close()
'our' is my table in database
This code error I'm facing in VS code
reply
File -e:\binu\c source\Python source\File I\sQLITEPRAC\our.py-, line 34, in delete_one-
c.execute(-DELETE FROM our WHERE rowid = (?)-,id)-
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 2 supplied.-
PS E:\binu\c source\Python source>
IM Facing This error
Function code is:-
def delete_one(id):-
conn = sqlite3.connect('datcustomer.db')-
c=conn.cursor()-
c.execute(-DELETE FROM our WHERE rowid = (?)-,id) -
conn.commit()-
conn.close()
'our' is my table in database
This code error I'm facing in VS code
reply
W0lfbane
Tutorial: You don't have to install Sql it's there automatically!
Reality: Sql missing directory or file path -
(clicks on another tutorial - how to install sqlite)
Good Grief. Also had to remind myself how to do formatting correctly, I can't stand lazy code.
reply
Tutorial: You don't have to install Sql it's there automatically!
Reality: Sql missing directory or file path -
(clicks on another tutorial - how to install sqlite)
Good Grief. Also had to remind myself how to do formatting correctly, I can't stand lazy code.
reply
itech
Thank you very much for your videos ! I have an issue when using sqlite3 and python at work. I'd like to importe datas in my table only if they are not in the table yet so I w'ont like to have same rows in my data base. How could I do that ? Thanks in advance !
reply
Thank you very much for your videos ! I have an issue when using sqlite3 and python at work. I'd like to importe datas in my table only if they are not in the table yet so I w'ont like to have same rows in my data base. How could I do that ? Thanks in advance !
reply
MrUNIXMan
I noticed something while using fetchone, each time it is called it goes down a row.
I assigned it to a variable to print a formatted output of the fields then used a for loop to iterate through total amounts of the database as I have only 5 entries.
reply
I noticed something while using fetchone, each time it is called it goes down a row.
I assigned it to a variable to print a formatted output of the fields then used a for loop to iterate through total amounts of the database as I have only 5 entries.
reply
Rafael
23:45 -> A data type is nothing but a way a machine will have to interpret a specific set of bits. Hey computer, get me space for this variable and prepare it to hold a number, a text or whatever else data type a language defines.
reply
23:45 -> A data type is nothing but a way a machine will have to interpret a specific set of bits. Hey computer, get me space for this variable and prepare it to hold a number, a text or whatever else data type a language defines.
reply
Juan
It would be good to show readonly vs read+write connections to the sqlite3 database file, which comes in handy if you're creating a flask web app which will be used by multiple individuals at once.
reply
It would be good to show readonly vs read+write connections to the sqlite3 database file, which comes in handy if you're creating a flask web app which will be used by multiple individuals at once.
reply
asth
Hi,
technical only - if you look at the contents of the sqlite database in any editor (even text), the data stored in it is freely readable, not encoded in any way.
how to solve it ?
reply
Hi,
technical only - if you look at the contents of the sqlite database in any editor (even text), the data stored in it is freely readable, not encoded in any way.
how to solve it ?
reply
freecodecamp
i'm stuck pretty early on - i'm using pycharm but when i type -import sqlite3- it doesn't become active, all the text stays gray and nothing happens when i run it?
reply
i'm stuck pretty early on - i'm using pycharm but when i type -import sqlite3- it doesn't become active, all the text stays gray and nothing happens when i run it?
reply
Jorge
Good tutorial, I wonder what can you do to allow non programmers to use the database, like a front end, I guess some ios or android app would be the first choice.
reply
Good tutorial, I wonder what can you do to allow non programmers to use the database, like a front end, I guess some ios or android app would be the first choice.
reply
COOKIE
In pycharm, my commands are all white in colour. Except import, I don't know what to do? it is giving me an error in the create table command????
reply
In pycharm, my commands are all white in colour. Except import, I don't know what to do? it is giving me an error in the create table command????
reply
Add a review, comment
Other channel videos
2:5:31
2:5:24
