# mysql-character-update

**Repository Path**: NanmiCoder/mysql-character-update

## Basic Information

- **Project Name**: mysql-character-update
- **Description**: 批量修改Mysql一个数据库中表、表字段的字符集
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-12-03
- **Last Updated**: 2024-11-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Introduction

This repository contains two Python scripts designed to work with a MySQL database. One script is designed to modify the character set of a specific column in all tables of a database. The other script is a sample program that uses the aiomysql library to interact with a MySQL database.

## Requirements

- Python 3.5+
- MySQL database
- aiomysql library

## Installation

To install the required `aiomysql` library, open a terminal and run:

```
pip install aiomysql
```

Make sure that you are running the command in the desired virtual environment, if you are using one.

## Usage

To modify the character set of a MySQL database, run the following command:

```
python main.py
```

This program demonstrates how to connect to a MySQL database using aiomysql, execute queries, and close the connection.

## License

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.