Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
sqlite3
#1
I want to insert my data into my table using variables. For example i want to insert data into table using ( data = input ("") )
What should i do?

import sqlite3 as sq3

conn = sq3.connect("Hacker.db")
#conn.execute('''CREATE TABLE Hack
# (ID INT PRIMARY KEY NOT NULL,
# NAME TEXT NOT NULL,
# AGE INT NOT NULL);''')
conn.execute("INSERT INTO Hack (ID,NAME,AGE) VALUES (1, 'PAUL', 17) ");
conn.execute("INSERT INTO Hack (ID,NAME,AGE) VALUES (2, 'PAUL', 17) ")
cursor = conn.execute("SELECT ID,NAME,AGE from Hack")
for row in cursor:
    print ("ID = " + str(row[0]) )
    print ("NAME = " + str(row[1]))
    print ("AGE = " + str(row[2]))
conn.close()
Reply


Messages In This Thread
sqlite3 - by kingram - Sep-13-2017, 09:19 AM
RE: sqlite3 - by buran - Sep-13-2017, 10:47 AM
RE: sqlite3 - by rajeev1729 - Sep-14-2017, 11:12 AM
RE: sqlite3 - by buran - Sep-14-2017, 11:41 AM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020