/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 vote192 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote148 views2 answers
Regex starts with
SQL
57 votes357 views6 answers
Mysql alter table add column
SQL
0 vote142 views1 answer
Find number of entries sql
SQL
0 vote124 views2 answers
Postgresql display subquery as json
SQL
4 votes185 views1 answer
Rename stored procedure in sql server
SQL
0 vote139 views1 answer
Python mysql query where
SQL
0 vote138 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
1 vote169 views1 answer
Psql connect
SQL
1 vote162 views1 answer
Insert value to new table by joining 2 different tables
SQL