/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 vote225 views1 answer
Ms sql - add one hour to time
SQL
4 votes272 views1 answer
Mysql insert from local csv
SQL
5 votes294 views1 answer
How to get all dates in a month in oracle
SQL
1 vote303 views1 answer
Round one decimal place mysql
SQL
0 vote300 views1 answer
Delete duplicate rows
SQL
12 votes274 views2 answers
Delete all data in neo4j
SQL
2 votes302 views1 answer
Datetrunc
SQL
20 votes340 views4 answers
Sql count if
SQL
11 votes297 views5 answers
Sql server reset identity
SQL
0 vote287 views3 answers
Joins and views sql
SQL