时越的博客

import pymysql db = pymysql.connect( host = 'localhost', user = 'root', password = '20150813', db = 'db1', charset = 'utf8' ) cursor = db.cursor() #执行sql语句 cursor.execute('select * from user where id = %s', (1,)) print(cursor.fetchall()