/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 vote190 views1 answer
Postgres truncate with cascade
SQL
0 vote164 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote179 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote159 views4 answers
How to drop all tables in sql
SQL
1 vote178 views2 answers
Mysql does sentance contain word
SQL
0 vote163 views1 answer
Stored function in sql
SQL
6 votes159 views1 answer
Postgres get size of database
SQL
1 vote170 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
5 votes152 views3 answers
Sql max value in column
SQL
1 vote148 views2 answers
Mysql current user
SQL