利用PYthon有条件查询SQL代码出错 cursor.execute(sql, {'id':0})

import pymysql

connection = pymysql.connect(host = 'localhost',
user='root',
password='123456',
database='MyDB',
charset='utf8')

try:
with connection.cursor() as cursor:

    # 执行SQL操作
    sql = 'select name, userid from user where user >% （id）s'
    cursor.execute(sql, {'id':0})
    #提取结果
    result_set = cursor.fetchall()

    for row in result_set:
        print('id:{0} - name:{1}', format([1],row[0]))

finally:
connection.close()

'select name, userid from user where user > %d'%0
这样看看