/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 vote134 views1 answer
Postgres 11 add primary key
SQL
0 vote128 views1 answer
Vowels in sql
SQL
5 votes134 views3 answers
Sql make column nullable
SQL
0 vote149 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote151 views1 answer
Get enginge db mysql
SQL
2 votes124 views2 answers
Function in sql
SQL
1 vote157 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote153 views1 answer
Check current sequence value postgres
SQL
0 vote181 views1 answer
Cahnge column name apex oracle
SQL
0 vote129 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL