/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 vote145 views1 answer
Postgres list tables and row counts
SQL
4 votes132 views3 answers
Oracle sql first day of quarter
SQL
0 vote125 views1 answer
Get who is hired in month in sql
SQL
0 vote141 views1 answer
Automatically update database last seen datetime in sql
SQL
1 vote128 views2 answers
Mysql trim whitespace
SQL
0 vote135 views2 answers
Sqlite unique
SQL
0 vote187 views1 answer
Store case result sql
SQL
0 vote157 views2 answers
Amazon linux postgresql client
SQL
19 votes141 views6 answers
What is mySQL
SQL
0 vote157 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL