/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 vote338 views1 answer
The package java.sql is not accessible
SQL
0 vote183 views1 answer
Mysql drop vs delete
SQL
0 vote166 views1 answer
Mysql export and import
SQL
0 vote184 views1 answer
Tinydb add table
SQL
0 vote182 views1 answer
Mysqldump don't drop table
SQL
6 votes243 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote162 views1 answer
Search In the Database using Text
SQL
0 vote176 views1 answer
Criteria builder select subset of column
SQL
1 vote129 views1 answer
Pagination sql
SQL
0 vote165 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL