/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 vote171 views5 answers
Mode sql course
SQL
7 votes207 views2 answers
Phpmyadmin change password
SQL
22 votes181 views3 answers
Year format in date mysql
SQL
1 vote161 views1 answer
Alter table column size oracle
SQL
0 vote175 views1 answer
Oracle table free space
SQL
0 vote169 views1 answer
Null column as zero in mysql
SQL
0 vote193 views1 answer
Sqlite get date only
SQL
2 votes208 views6 answers
In operator in sql
SQL
2 votes158 views2 answers
Function in sql
SQL
0 vote171 views2 answers
Py sqlite if entry exists
SQL