coding=utf-8

import mysql.connector

conn = mysql.connector.connect(user='root', password='lby121121', database='local_paul_db') cursor = conn.cursor() cursor.execute('create table user(id int auto_increment,name varchar(10),age int,primary key(id))ENGINE=InnoDB') cursor.execute('insert into user(name,age) values(%s,%s)', ['paul', '28']) print("cursor.rowcount:", cursor.rowcount)

conn.commit() cursor.close()

cur = conn.cursor() cur.execute('select * from user where name = %s', ['paul', ]) print("cur.fetchall():", cur.fetchall()) cur.close() conn.close()