/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

0 vote369 views1 answer
Replace divide by zero error with 0 in sql
SQL
1 vote393 views2 answers
Mysql update LAST_INSERT_ID()
SQL
16 votes335 views1 answer
CTE statement sql server
SQL
0 vote368 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote396 views1 answer
Postgres see sequence current state
SQL
4 votes420 views2 answers
Sql display today's date
SQL
0 vote348 views1 answer
Mysql coonect sample code
SQL
2 votes356 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote406 views1 answer
PGSQL dynamic table name
SQL
1 vote342 views1 answer
Postgresql filter on
SQL