基于迎新管理信息系统的宁夏高校新生数据处理方案
CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
student_id VARCHAR(20) NOT NULL UNIQUE,
name VARCHAR(50) NOT NULL,
major VARCHAR(50),
phone VARCHAR(15)
);
]]>
学号,姓名,专业,电话
20230001,张三,计算机科学,12345678901
...
import csv
import mysql.connector
# 连接数据库
conn = mysql.connector.connect(
host='localhost',
user='root',
password='password',
database='university'
)
cursor = conn.cursor()
# 打开CSV文件并读取数据
with open('students.csv', 'r') as file:
reader = csv.reader(file)
next(reader) # 跳过表头
for row in reader:
cursor.execute("INSERT INTO students (student_id, name, major, phone) VALUES (%s, %s, %s, %s)", row)
conn.commit()
cursor.close()
conn.close()
print("数据导入完成！")
]]>
SELECT major, COUNT(*) AS count FROM students GROUP BY major;
本站知识库部分内容及素材来源于互联网，如有侵权，联系必删！