/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

27 votes266 views3 answers
Mysql show tables in database
SQL
3 votes252 views1 answer
Oracle apex call duration
SQL
5 votes242 views1 answer
How to check nls timestamp format in oracle
SQL
2 votes315 views3 answers
Sql delete duplicate
SQL
0 vote248 views4 answers
Sql year
SQL
2 votes262 views1 answer
Mysql clear screen
SQL
0 vote250 views1 answer
Oracle sql date winter time
SQL
0 vote259 views1 answer
Search starting with mysql
SQL
0 vote251 views1 answer
How to connect postgresql database with java
SQL
0 vote266 views1 answer
Mysql wait_timeout
SQL