pymysql

 

 

 

user = input("name:")
pwd = input("mima:")


conn = pymysql.Connect(host = '10.0.0.100',port=3306,user='root',password='123456',database='db1',charset='utf8')
cursor = conn.cursor()
sql ='select * from user where name="%s" and password="%s"' %(user,pwd,)

v = cursor.execute(sql)
result = cursor.fetchall()
cursor.close()  ##关闭
conn.close()    ##关闭
print(result)

 

import pymysql

# 获取数据
conn = pymysql.Connect(host='192.168.12.89',port=3306,user='root',password="123",database="s17day11db",charset='utf8')
cursor = conn.cursor()

cursor.execute('insert into class(caption) values(%s)',['新班级'])
conn.commit()
new_class_id = cursor.lastrowid # 获取新增数据自增ID

cursor.execute('insert into student(sname,gender,class_id) values(%s,%s,%s)',['李杰','男',new_class_id])
conn.commit()

cursor.close()
conn.close()