# Pymysql_Utils

**Repository Path**: kid-kid/Pymysql_Utils

## Basic Information

- **Project Name**: Pymysql_Utils
- **Description**: python+pymysql 操作数据库。实现MySQL的增删改查
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2025-09-04
- **Last Updated**: 2025-12-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Pymysql_Utils

#### 介绍
python+pymysql 操作数据库

#### 软件架构
 :sake: **student_system.sql  ->数据库文件**



**创建数据问语句：**

```SQL
CREATE TABLE student(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
student_number VARCHAR(10) NOT NULL UNIQUE,
student_name VARCHAR(255) NOT NULL,
chinese FLOAT DEFAULT(0),
math FLOAT DEFAULT(0),
english FLOAT DEFAULT(0)
);
```