/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 vote300 views1 answer
Python escape mysql
SQL
2 votes356 views1 answer
Tcl in sql
SQL
6 votes297 views4 answers
Delete table sqlite
SQL
2 votes303 views3 answers
Current setting postgres timezone
SQL
1 vote297 views1 answer
Data type and their numeric form
SQL
0 vote311 views1 answer
Check if a column is a primary key in sql server
SQL
4 votes306 views2 answers
Linq join
SQL
0 vote300 views1 answer
Sql list dates between two dates
SQL
0 vote288 views1 answer
Casterar postgres
SQL
0 vote275 views1 answer
Postgresql add not null and not empty constraint
SQL