import pymysql
import datetime

def insert_table():
    db = pymysql.connect(host='localhost',user='root',password='root',db='text')
    cursor = db.cursor()

    # 数据插入语句
    sql ="insert into employee(first_name,last_name,age,sex,income,create_time) values('%s','%s',%d,'%s',%d,'%s')"%('三','万',20,'男',2000.88,datetime.datetime.now())
    try:
        cursor.execute(sql)
        db.commit()
        print('success!')
    except Exception as e:
        print(f'{e}')
        db.rollback()
    finally:
        db.close()

if __name__ == '__main__':
    insert_table()