import pymysql

conn = pymysql.connect('localhost', 'root', 'kxc_2011', 'testdb') cursor = conn.cursor()

cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')

cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael']) cursor.execute('insert into user (id, name) values (%s, %s)', ('4', 'Jack')) user_id = '2' user_name = 'suki' cursor.execute('insert into user values("%s", "%s")' % (user_id, user_name))

cursor.execute('insert into user (id, name) values ("%s", "%s")' % ('3', 'Adam'))

print(cursor.rowcount)

conn.commit() cursor.close()

cursor = conn.cursor() cursor.execute('select * from user where id = %s', '4')

#cursor.execute('select * from user where id = "%s"' % '2') values = cursor.fetchall() value = cursor.fetchone() print(values) print(value) cursor.close() conn.close()

上面插入1/2/3/4条记录都是用不同sql语句插入的，都可以成功插入。 另外，fetchone(): 该方法获取下一个查询结果集。结果集是一个对象 这个是其他网页教程的注释。没看懂。每次插入后，这个方法获取的都是None.