PYTHON

python insert

# The insert() method inserts an element to the list 
# at a given index.
# Syntax: list_name.insert(index, element)
my_list = ["Add", "Answer"]
my_list.insert(1, "Grepper")
print (my_list)
> ['Add', 'Grepper', 'Answer']

insert data in table python

import sqlite3
connection= sqlite3.connect('sqlite.db')
cursor = connection.cursor()
cursor.execute('''CREATE TABLE if not Exists Website
               (Post text, Autor text, Views real)''')

post_text = 'this is a raw  post'
post_author = 'alixapordev'
post_views = 6900

INSERT_QUERY = f"INSERT INTO Website VALUES ('{post_text}','{post_author}','{post_views}')"
cursor.execute(INSERT_QUERY)
# Save (commit) the changes
connection.commit()
# close connection
connection.close() 
   

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()

insert in Python

# insert method places an element at an index you specify

foo = [1, 2, 3, 4]
foo.insert(1, 0.5)
print(foo)

# Output - [1, 0.5, 2, 3, 4]

insert python

list_of_names = ["John", "Mike"]
print(list_of_names)
 
list_of_names.insert(0,"Amy")  #insert Amy as the first item, at index 0
print(list_of_names)
 
list_of_names.insert(2,"Mario") #insert Mario as the third item, at index 2
print(list_of_names)

#['John', 'Mike']
#['Amy', 'John', 'Mike']
#['Amy', 'John', 'Mario', 'Mike']