Answer the question
In order to leave comments, you need to log in
How to fix error in sqlite3 python?
Whatever I enter in Login, password and secret, it shows that such an entry already exists...
Login: 11
Password: 11
Secret: 11
Such an entry already exists!
('123', '123', 0)
My code:
import sqlite3
db = sqlite3.connect('server.db')
sql = db.cursor()
sql.execute("""CREATE TABLE IF NOT EXISTS users (
login TEXT,
password TEXT,
secret TEXT,
cash BIGINT
)""")
db.commit()
user_login = input('Login: ')
user_password = input('Password: ')
user_secret = input('Secret: ')
sql.execute ("SELECT login FROM users")
if sql.
sql.execute("INSERT INTO users VALUES (?, ?, ?, ?)", (user_login, user_password, user_secret, 0))
db.commit()
print('Login succeeded!')
else:
print('This record already exists!')
for value in sql.execute("SELECT * FROM users"):
print(value)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question