/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 vote122 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote130 views2 answers
Generate sql trigger through ef migration
SQL
3 votes116 views1 answer
Delete all content in table mysql
SQL
0 vote135 views2 answers
Get item by composite primary key mysql
SQL
11 votes246 views2 answers
Import mysql dump command line windows
SQL
0 vote118 views1 answer
Check duplicate values plsql
SQL
0 vote142 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
3 votes177 views3 answers
Mysql get table size
SQL
1 vote141 views2 answers
Select only columns that are not empty oracle sql
SQL
2 votes174 views1 answer
Db.relationship sqlalchemy flask
SQL