/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 table statistics last analyzed
SQL
150 votes303 views10 answers
Grepper
SQL
0 vote116 views1 answer
Running query in redshift
SQL
0 vote153 views1 answer
Sqlcl format
SQL
22 votes132 views4 answers
Mysql date_format
SQL
0 vote125 views1 answer
Psql initialization
SQL
0 vote153 views1 answer
In query in sql
SQL
0 vote193 views1 answer
Placements hackerrank solution
SQL
0 vote142 views1 answer
Test database for sql
SQL
0 vote189 views1 answer
Replace null value within column mysql
SQL