/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

4 votes120 views1 answer
Oracle show errors compilation
SQL
1 vote144 views1 answer
Mysql strict_trans_tables
SQL
0 vote113 views1 answer
Sql cross apply vs join
SQL
0 vote118 views1 answer
Mysql group rows with same value
SQL
8 votes82 views2 answers
Alter column name in mssql
SQL
0 vote127 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote126 views1 answer
Will graphql replace sql
SQL
2 votes125 views1 answer
Cast string to datetime mysql
SQL
0 vote140 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote116 views1 answer
Sqlalchemy sequence postgresql
SQL