/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 vote196 views1 answer
Sqlite higher or equal
SQL
21 votes186 views3 answers
Sql average
SQL
0 vote189 views1 answer
Mariadb number format
SQL
1 vote190 views1 answer
Oracle update with sequence
SQL
8 votes235 views1 answer
Oracle add datafile to tablespace
SQL
1 vote194 views2 answers
Mysql remove first and last character from string
SQL
0 vote196 views1 answer
Mysql exception output
SQL
0 vote268 views1 answer
Varchar2 length in oracle
SQL
-1 vote187 views1 answer
Mysql order by on condition
SQL
4 votes196 views2 answers
Postgre sql create table
SQL