PyMysql

import pymysql


conn = pymysql.connect(host="10.37.129.3",port=3306,user="egon",passwd="123456",db="homework",charset="utf8")

cursor = conn.cursor()


#方式一:

sql = "select * from course where cid=1"
effect_row = cursor.execute(sql)


# 方式二：
sql = "select * from course where cid=‘%s‘" %(1,)
effect_row = cursor.execute(sql)


# 方式三  普通  列表
sql = "select * from course where cid=‘%s‘"

effect_row = cursor.execute(sql,1)
effect_row = cursor.execute(sql,[1])


# 方式四  字典格式

sql = "select * from course where cid=‘%(u)s‘"
effect_row = cursor.execute(sql,{"u":1})


row_1 = cursor.fetchone()

cursor.close()
conn.close()

print(row_1)

import pymysql


conn = pymysql.connect(host="10.37.129.3",port=3306,user="egon",passwd="123456",db="student_info",charset="utf8")

cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)



sql = "select * from student_info where sid > %s "

effect_row = cursor.execute(sql,[1])


row_1 = cursor.fetchone()
row_2 = cursor.fetchone()
row_3 = cursor.fetchone()

cursor.close()
conn.close()

print(row_1)
print(row_2)
print(row_3)

import pymysql


conn = pymysql.connect(host="10.37.129.3",port=3306,user="egon",passwd="123456",db="student_info",charset="utf8")

cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)


#插入一行
# sql = "insert into student_info(sname,gender,class_id) VALUES(‘alex1‘,‘女‘,2)"

#插入多行
sql = "insert into student_info(sname,gender,class_id) VALUES(‘alex1‘,‘女‘,2),(‘alex2‘,‘女‘,2),(‘alex3‘,‘女‘,2)"


#
sql = "insert into userinfo(username,password) values(%s,%s)"
# 受影响的行数
r = cursor.executemany(sql,[(‘egon‘,‘sb‘),(‘laoyao‘,‘BS‘)])




r = cursor.execute(sql)

conn.commit()
cursor.close()
conn.close()

print(r)

插入 演示

import pymysql

conn = pymysql.connect(host="localhost",user=‘root‘,password=‘‘,database="db666")
cursor = conn.cursor()
sql = "insert into userinfo(username,password) values(‘asdfasdf‘,‘123123‘)"
cursor.execute(sql)
conn.commit()
print(cursor.lastrowid)
cursor.close()
conn.close()