access转换mysql

# 示例代码：Python脚本转换数据类型
import pymysql
import pyodbc

# 连接Access数据库
access_conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path_to_your_access_db.accdb;')
access_cursor = access_conn.cursor()

# 连接MySQL数据库
mysql_conn = pymysql.connect(host='localhost', user='user', password='password', db='database_name')
mysql_cursor = mysql_conn.cursor()

# 查询Access表
access_cursor.execute("SELECT * FROM your_table")
rows = access_cursor.fetchall()

# 插入到MySQL
for row in rows:
    # 根据需要调整数据类型
    mysql_cursor.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", (row[0], row[1]))

mysql_conn.commit()
mysql_conn.close()
access_conn.close()

-- 设置MySQL字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 示例：创建MySQL存储过程
DELIMITER //
CREATE PROCEDURE GetComplexData()
BEGIN
    SELECT column1, column2
    FROM your_table
    WHERE condition = 'value';
END //
DELIMITER ;