/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

3 votes163 views1 answer
Postgres update column with value from another table
SQL
2 votes170 views1 answer
Mysql application.properties spring boot
SQL
0 vote175 views1 answer
Teller stamp , bmo , PDF
SQL
-2 votes187 views1 answer
Trunc in sql
SQL
0 vote175 views1 answer
Cross apply top for each row t1
SQL
3 votes168 views1 answer
Oracle APEX elapsed time
SQL
0 vote177 views1 answer
Change date format in oracle query
SQL
1 vote173 views1 answer
Simple project for database
SQL
2 votes176 views6 answers
Mysql change timezone
SQL
1 vote173 views1 answer
Apex select list ORA-20999
SQL