Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

python data insert

import sqlite3 
# python data insert 
conn = sqlite3.connect('TestDB.db') 
name=input("enter your name 
 ")
conutryID=int(input("enter your country id 
 "))
sql = f''' INSERT INTO CLIENTS(Client_Name,Country_ID,Date)
              VALUES('{name}',"{conutryID}","30/3/2022") '''
conn.execute(sql)
conn.commit()
conn.close()
 
PREVIOUS NEXT
Tagged: #python #data #insert
ADD COMMENT
Topic
Name
4+1 =