/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 vote147 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote143 views1 answer
Django mysqlclient connection string
SQL
1 vote137 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote142 views1 answer
List in one column mysql
SQL
1 vote133 views1 answer
Postgres get month name from date
SQL
0 vote157 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote152 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote148 views1 answer
Mysql change innodb to myisam
SQL
0 vote146 views1 answer
Mysql drop vs delete
SQL
1 vote127 views1 answer
Create table tablename as select * from tablename
SQL