python删除数据库表中全部内容

import pymysql

 

# 创建连接

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='1234567890', db='studentmemo')

# 创建游标

cursor = conn.cursor()

 

# 执行SQL，并返回收影响行数

effect_row = cursor.execute("delete from studentmemo.student_study")

conn.commit()

 

# 关闭游标

cursor.close()

# 关闭连接

conn.close()