On Wed, Nov 19, 2008 at 4:48 PM, amit sethi <[EMAIL PROTECTED]>
wrote:
> 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)
You may try:
c.execute("insert into ABC(%s) values('%s')" % (list1_value, list2_value))
regards,
shantanoo
--
Fred Allen - "An associate producer is the only guy in Hollywood who will
associate with a producer."
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
