/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 vote357 views1 answer
Mysql update inner
SQL
0 vote408 views1 answer
Restart serial number for postgres
SQL
2 votes340 views2 answers
Postgres timestamp to datetime
SQL
10 votes329 views2 answers
Select nextval from sequence oracle
SQL
0 vote325 views1 answer
Oracle create job if not exists
SQL
7 votes327 views1 answer
Sql server management studio turn on line numbers
SQL
4 votes348 views1 answer
Sql select limit range
SQL
10 votes309 views6 answers
Between sql
SQL
4 votes314 views2 answers
Oracle sql group by date year
SQL
7 votes394 views2 answers
Drop index oracle
SQL