/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 vote339 views3 answers
Update from select sqlite
SQL
1 vote331 views1 answer
How to find median of a column sql
SQL
0 vote327 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote323 views1 answer
Postgresql isnull with max
SQL
0 vote346 views1 answer
Where date in datetime mysql
SQL
-1 vote340 views1 answer
Capitole toulouse
SQL
0 vote329 views1 answer
Turn on foreign keys check mysql
SQL
0 vote432 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote346 views1 answer
Postgres create extension if not exists
SQL
4 votes391 views2 answers
Postgresql float data type
SQL