/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 vote149 views5 answers
What is in operator in sql
SQL
0 vote129 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
-1 vote142 views3 answers
Update mongodb version ubuntu
SQL
1 vote135 views3 answers
Union SQL
SQL
0 vote135 views1 answer
Mysql search multiple tables
SQL
0 vote130 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
4 votes142 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote142 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
5 votes230 views1 answer
Oracle asynchronous procedure
SQL
11 votes149 views1 answer
Sql insert multiple rows from select
SQL