I want to insert data in mysql table by user command. But i can't understand why cannot execute code. Code sample:
user_name= input("What is your name?:\n")
user_phone= input("What is your phone:\n")
user_city= input("Your city:\n")
myCursor.execute("insert into information(name,phone, city) values(user_name, user_phone, user_city);")
print("Insert successfully")
import pymysql
con = pymysql.connect("Host", "Username", "Password", "Database")
cur = con.cursor()
#taken from sample displayed
user_name = input("What is your name?:\n")
user_phone = int(input("What is your phone number:\n"))
user_city = input("Your city:\n")
cur.execute("insert into information(name,phone, city) values('{}', {},
'{}')".format(user_name, user_phone, user_city))
con.commit()
con.close()
c'); DROP TABLE information -- at the Your city: prompt. Always use the parameters or args argument of the execute* methods to pass parameters to your queries.you need to define below variables in order to use execute.
import cx_Oracle
DSN_TNS = cx_Oracle.makedsn(IP, PORT, SID)
DB_CRED = cx_Oracle.connect(USERNAME, PASSWORD, DSN_TNS)
curs = DB_CRED.cursor()
user_name= input("What is your name?:\n")
user_phone= input("What is your phone:\n")
user_city= input("Your city:\n")
sql_query = "insert into information(name,phone, city) values('{0}','{1}','{2}')".format(user_name, user_phone, user_city)
curs.execute(sql_query)
DB_CRED.commit()
DB_CRED.close()
c'); DROP TABLE information -- at the Your city: prompt. Always use the parameters or args argument of the execute* methods to pass parameters to your queries.
execute method. E.g. cursor.execute("INSERT INTO table (col1, col2) VALUES (:1, :2)", ('value1', 'value2')) Have a look at the official docs I linked in my other comment and see some more elaborate examples in this tutorial.mysql. The cursor's paramstyle differs from driver to driver.