/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

2 votes147 views1 answer
Mysql add boolean column
SQL
0 vote174 views1 answer
Check if mysql db is used
SQL
1 vote160 views1 answer
Select from describe sql
SQL
0 vote145 views1 answer
Default column value in sql same as other column
SQL
2 votes135 views1 answer
How to delete columns in sql
SQL
0 vote166 views1 answer
Datagrip execute procedure
SQL
1 vote163 views1 answer
Sql random sampling per group
SQL
1 vote168 views3 answers
Mysql on delete set null
SQL
0 vote164 views1 answer
T sql dynamic top n query
SQL
0 vote166 views1 answer
Postgres reorder columns
SQL