python的mysql 2

import pymysql

1.连接数据库

conn = pymysql.connect(host='localhost',
                       user='root',
                       password='redhat',
                       db='westos',
                       charset='utf8',
                       autocommit='True'
)

2.创建游标对象

cur = conn.cursor()

3.对数据库操作

3.1插入数据

try:
   inser_sqli = "insert into hello values(3,'apple');"
   cur.execute(inser_sqli)
except Exception as e:
    print('插入数据失败:',e)
else:

# 如果是插入数据 一定要提交的 不然数据库中找不到要插入的数据
    conn.commit()
    print('插入数据成功！！')

3.2 插入多条数据

try:
    info = [(i,i) for i in range(100,1000)]
    # 第一种方式
    # inser_sqli = "insert into hello values(%d,'%s');"
    # for item in info:
    #     print('insert语句：',inser_sqli %item)
    #     cur.execute(inser_sqli %item)
    # 第二种方式
    inser_sqli = "insert into hello values('%s','%s');"
    cur.executemany(inser_sqli,info)
except Exception as e:
    print('插入多条数据失败:',e)
else:
    print('插入多条数据成功')