#创建表
#导入pymysql import pymysql #创建链接 con = pymysql.connect(host='localhost',user='root',password='123456',database='zhy',port=3306) #创建游标对象 cur = con.cursor() #编写创建表的sql sql = """ create table t_student( sno int primary key auto_increment, sname varchar(30) not null, age int(20), score float(3,1) ) """ #执行sql try: cur.execute(sql) print("创建表成功") except Exception as e: print(e) print("创建失败") finally: cur.close() con.close()
#插入表
#导入模块 import pymysql #窗帘连接 con = pymysql.connect(host='localhost',user='root',password='123456',port=3306,database='zhy') #创建游标对象 cur = con.cursor() #编写sql语句 sql = 'insert into t_student (sname,age,score) value(%s,%s,%s)' try: #执行sql #cur.execute(sql, ('王五', 20, 85))#插入一条数据 cur.executemany(sql,[('王五',20,85),('张三',18,20),('王五',19,23)]) #插入多条数据 #提交事务 con.commit() print("插入成功") except Exception as e: print(e) con.rollback() print("执行插入数据失败") finally: #关闭连接 con.close() cur.close()