MySQL Error #1064 in Python Programming

[cpiyush]

Hello,

I am trying to insert values in a MySQL table using Python as front end, but facing this problem.

table structure:-(Name:- namespace)
Fields
prifex-----------------varchar(20)
namespace--------varchar(100)

Code:-

    global prefix_dict
    global dbConn
 
    keys=[]
    i=0
    prefix=''
    nmspace=''
 
    keys=prefix_dict.keys()
 
    while i<len(keys):
        prefix=keys[i]
        nmspace=prefix_dict[keys[i]]
        s="""("""+str(prefix)+""","""+str(nmspace)+""")"""
        print "--------------------------------------------"
        print s
        print "--------------------------------------------"
        s1="""INSERT INTO namespace VALUES"""+s
        print s1
        dbConn.query(s1)
                                i+=1
 

Output:-

--------------------------------------------
(default,<http://Demo:Remo@172.21.107.145:8080/SfleXProd/#>)
--------------------------------------------

INSERT INTO namespace VALUES(default,<http://Demo:Remo@172.21.107.145:8080/SfleXProd/#>)
    dbConn.query(s1)

_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax
; check the manual that corresponds to your MySQL server version for the right s
yntax to use near '<http://Demo:Remo@172.21.107.145:8080/SfleXProd/#>)' at line
1")


Problem:-
I am using variable names instead of literal values in the insert statement & not getting the correct syntax, although when I am using literal values i am getting the success.

plz help me that how to use variable names in insert query.

[bartonc]

Hello,

Problem:-
I am using variable names instead of literal values in the insert statement & not getting the correct syntax, although when I am using literal values i am getting the success.

plz help me that how to use variable names in insert query.

I do that all the time. See this thread.