<filename>eyegaze_insert.py<gh_stars>0
import mysql.connector

mydb = mysql.connector.connect(
    host = 'localhost',
    user = "root",
    #passwd = "<PASSWORD>",
    database = "spl"
    #auth_plugin='mysql_native_password'
    )
myCursor = mydb.cursor()
#myCursor.execute("CREATE database test222")
sql="insert into  eyegazeContent( video ) values( %s)"
val=("/home/anika/Downloads/pattern.mp4",)
myCursor.execute(sql,val)
mydb.commit()
myCursor.close()
mydb.close()


<filename>eyegaze_insert.py<gh_stars>0
import mysql.connector

mydb = mysql.connector.connect(
    host = 'localhost',
    user = "root",
    #passwd = "<PASSWORD>",
    database = "spl"
    #auth_plugin='mysql_native_password'
    )
myCursor = mydb.cursor()
#myCursor.execute("CREATE database test222")
sql="insert into  eyegazeContent( video ) values( %s)"
val=("/home/anika/Downloads/pattern.mp4",)
myCursor.execute(sql,val)
mydb.commit()
myCursor.close()
mydb.close()


#passwd = "<PASSWORD>", #auth_plugin='mysql_native_password' #myCursor.execute("CREATE database test222")