Hi , i am trying to learn python and this is my first time with any databases . I am using sqlite3 to create a database of my music files and its metadata tags so here is what i wanted to do . Two list one of the attributes and one of their values ,how do i put it in the database.Here is a simple code i think should work but isn't? >>> import sqlite3 >>> conn=sqlite3.connect('/tmp/example2') >>> c = conn.cursor()
>>> list1=['hello','hi'] >>> list2=['a','b'] >>>c.execute('''create table ABC(hello text,hi text)''') >>> list1_value= ",".join(list1) >>> list2_value= ",".join(list2) >>> c.execute('''insert into ABC (%s) values (%s)''')%(list1_value,list2_value) This is the error it generates sqlite3.OperationalError: near "%": syntax error why doesn't this work . Can someone please explain A-M-I-T S|S
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor