/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

4 votes216 views2 answers
Postgresql reset sequence
SQL
1 vote236 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote212 views1 answer
Mysql into outfile with headers
SQL
11 votes220 views3 answers
Change column name sql server management studio
SQL
4 votes224 views4 answers
Rollback in sql
SQL
1 vote211 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote218 views1 answer
Sql server select ignore dupplicates
SQL
0 vote224 views1 answer
Jdbc sql connection string
SQL
0 vote178 views1 answer
Postgres delete where id in
SQL
2 votes208 views1 answer
Select * from table where name like
SQL