0

Traceback (most recent call last): File "/home/hacker47/Documents/programming/python/ubin/sql_c.py", line 11, in url_cursor.execute(f"INSERT INTO url(Date,Time,Urls) VALUES ({datetime.today().strftime('%B_%d_%Y')},{datetime.today().strftime('%H:%M:%S')}, '1')") sqlite3.OperationalError: near ":45": syntax error

import sqlite3
from datetime import datetime


url_con = sqlite3.connect("url.db")

url_cursor = url_con.cursor()

print(f"INSERT INTO url VALUES ({datetime.today().strftime('%B_%d_%Y')}, {datetime.today().strftime('%H:%M:%S')}, 1)")

url_cursor.execute(f"INSERT INTO url(Date,Time,Urls) VALUES ({datetime.today().strftime('%B_%d_%Y')},{datetime.today().strftime('%H:%M:%S')}, '1')")

url_con.commit()

url_con.close()

0 Answers0