/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 vote190 views1 answer
Psql filed name alter
SQL
0 vote203 views1 answer
Oracle table privileges
SQL
0 vote224 views1 answer
Prisma transaction
SQL
0 vote191 views1 answer
Plsql find location of procedure
SQL
0 vote191 views1 answer
Sqlite higher or equal
SQL
2 votes142 views1 answer
Oracle current date without time
SQL
0 vote194 views1 answer
How to find sql server name
SQL
23 votes194 views6 answers
How to create table in sql
SQL
1 vote181 views1 answer
Postgres get timestamp
SQL
0 vote146 views1 answer
Finish transaction sql
SQL