/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

16 votes200 views1 answer
Mysql mediumint max value
SQL
11 votes219 views4 answers
Reset identity column values in sql server
SQL
0 vote198 views1 answer
Sql shell psql cannot enter password
SQL
0 vote216 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
5 votes175 views2 answers
Create table
SQL
2 votes206 views5 answers
SQL trigger
SQL
0 vote159 views1 answer
Get last run query sql server
SQL
1 vote146 views1 answer
Metada in sql
SQL
0 vote195 views1 answer
Resullt all update knex mysql
SQL
1 vote180 views1 answer
Foreign key constraint in ms sql
SQL