/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 vote192 views1 answer
Get first name and last name from full name string in SQL
SQL
-1 vote197 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
3 votes215 views1 answer
Stpop start psql server
SQL
0 vote228 views1 answer
Oracle winter time change
SQL
2 votes192 views3 answers
3 days back in sql server
SQL
0 vote203 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote203 views1 answer
Mariadb errno 121
SQL
0 vote202 views2 answers
Sql server select first day of previous year
SQL
2 votes209 views3 answers
Mysql pass command from command line
SQL
0 vote257 views2 answers
How to check if a column exists in a SQL Server table?
SQL