MySQL Forums
Forum List  »  Connector/Python

Advanced Search
New Topic

Re: Using Python variables in MySQL INSERT statement SOLVED
Posted by: Huu Da Tran
Date: June 06, 2008 03:46PM

Better let the module work for you to avoid sql injection... 
cur.execute(u'''insert into `data` values (%s, %s, %s)''',
        currtime, currtemp, currsat)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Using Python variables in MySQL INSERT statement
Cheese Cake
June 03, 2008 11:58AM
Re: Using Python variables in MySQL INSERT statement SOLVED
Cheese Cake
June 04, 2008 12:51PM
Re: Using Python variables in MySQL INSERT statement SOLVED
Huu Da Tran
June 06, 2008 03:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.