/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 votes297 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes283 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote284 views1 answer
Find how many tables in database sql query
SQL
2 votes279 views2 answers
Mysql find max value row
SQL
4 votes293 views1 answer
Postgresql list sequences
SQL
2 votes263 views1 answer
Apex date today add days
SQL
3 votes283 views2 answers
Install mysql powershell
SQL
10 votes267 views4 answers
Join with multiple conditions sql
SQL
0 vote276 views1 answer
Longtext sql
SQL
1 vote296 views3 answers
How to create a table structure from another table in mysql
SQL