/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 vote214 views1 answer
Mysql cast null to string
SQL
0 vote149 views1 answer
Bigquery information_schema schema all columns
SQL
3 votes193 views2 answers
Oracle sql drop sequence
SQL
53 votes598 views6 answers
How to install mysql ubuntu
SQL
1 vote188 views1 answer
Sql server 2012 query history
SQL
6 votes201 views2 answers
Can't connect to local mysql server through socket
SQL
2 votes199 views2 answers
Set database timezone mysql
SQL
24 votes209 views5 answers
List mysql users
SQL
2 votes198 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote200 views1 answer
Sqlite higher or equal
SQL