/SQL/Python sql passer des parametres dans une requet pymysql

Python sql passer des parametres dans une requet pymysql

# Connect to db
# Open a cursor
stmt = "SELECT * FROM users WHERE username = %(user)s"
cursor.execute(stmt, {"user": "bob"})
user = cursor.fetchone()
print user

{"username": "bob", "alias": "bobby", "avatar": "default", "fullname": "bob"}

Source: living-sun.com

Similar codes

0 vote351 views1 answer
Connecting mySQL to STS
SQL
0 vote358 views1 answer
Mysql reset wp_options
SQL
1 vote320 views1 answer
PLS-00225 type
SQL
0 vote341 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
3 votes478 views9 answers
Linq to sql converter online
SQL
17 votes340 views4 answers
Sort by mysql
SQL
0 vote339 views1 answer
Sql insert query list of dictionaries
SQL
0 vote315 views1 answer
How to increase the width of the screen in oracle
SQL
9 votes321 views1 answer
Oracle get table schema
SQL
0 vote314 views1 answer
Provera dupliranih konatakata
SQL