/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 vote185 views2 answers
How to set global time_zone in mysql
SQL
0 vote181 views1 answer
Mysql date only no time
SQL
8 votes183 views1 answer
Oracle search code in packages
SQL
9 votes175 views6 answers
Sql add column with default value
SQL
3 votes165 views1 answer
What is having clause
SQL
1 vote182 views1 answer
Postgres set column based on another column
SQL
1 vote218 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
1 vote195 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
3 votes165 views1 answer
Sql select all
SQL
3 votes219 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL