/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

1 vote171 views1 answer
How to set up a trigger in sql
SQL
16 votes159 views2 answers
Sql exists
SQL
4 votes150 views1 answer
Id primary key auto generated
SQL
0 vote153 views1 answer
How to count null values in sql
SQL
3 votes147 views2 answers
To_char sql
SQL
0 vote156 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote148 views1 answer
Hibernate xml property MySQL url, username and password
SQL
-1 vote173 views1 answer
Mysql select count if contains
SQL
0 vote148 views1 answer
Mysql show category once count how many products
SQL
0 vote152 views1 answer
Convert rows to columns in sql server
SQL