/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 vote244 views1 answer
SQL query to verify the size of the table
SQL
0 vote228 views1 answer
Database timezone
SQL
0 vote295 views1 answer
What is common table expression in sql
SQL
0 vote230 views1 answer
Sqlite closes value
SQL
0 vote228 views1 answer
Sql delete where x or y or z
SQL
0 vote229 views1 answer
Postgresql default value boolean
SQL
3 votes223 views1 answer
Oracle apex warning message
SQL
0 vote242 views1 answer
Postgresql on conflict pair
SQL
13 votes258 views5 answers
Alter table query sql server change column
SQL
4 votes301 views1 answer
Oracle table statistics
SQL