/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 vote104 views1 answer
Table information in sql server
SQL
0 vote104 views1 answer
Postgresql print variable
SQL
0 vote103 views1 answer
Sql constarint
SQL
0 vote98 views1 answer
Sql insert tuple
SQL
1 vote148 views1 answer
Delete mysql ubuntu 20.04
SQL
1 vote109 views1 answer
Base64 encode sql server
SQL
1 vote115 views1 answer
Sql server insert into temp table
SQL
0 vote104 views1 answer
T-sql check if data exists
SQL
5 votes97 views1 answer
Update sql user password
SQL
0 vote133 views1 answer
Select all same column value in sql
SQL