/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 vote141 views2 answers
Sql where keyword
SQL
0 vote142 views1 answer
Sql find record cannot cast date
SQL
0 vote133 views1 answer
Postgres call view
SQL
0 vote138 views1 answer
QUERY JPQL
SQL
0 vote143 views1 answer
Mysql zerofill
SQL
0 vote147 views1 answer
Query string starts with vowels
SQL
1 vote188 views1 answer
Add time to date sql
SQL
0 vote133 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
3 votes159 views3 answers
1396(hy00) mysql error
SQL
0 vote141 views1 answer
St_buffer mysql
SQL