/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

2 votes274 views2 answers
Oracle no data found error code
SQL
0 vote307 views1 answer
Mysql url
SQL
0 vote246 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote331 views3 answers
How to find all role in mysql
SQL
6 votes270 views1 answer
Oracle desc table primary key
SQL
0 vote338 views1 answer
Sqlite schema structure of a relational database
SQL
8 votes247 views2 answers
Alter column name in mssql
SQL
4 votes274 views2 answers
Sql table
SQL
1 vote283 views1 answer
Backup mysql data only
SQL
0 vote282 views1 answer
How to change null display in psql
SQL