mdf用mysql怎么打开

import pyodbc
import pymysql

# 连接到SQL Server
conn_sql_server = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
cursor_sql_server = conn_sql_server.cursor()

# 导出数据
cursor_sql_server.execute("SELECT * FROM your_table")
rows = cursor_sql_server.fetchall()

# 连接到MySQL
conn_mysql = pymysql.connect(host='your_mysql_host', user='your_mysql_username', password='your_mysql_password', db='your_mysql_database')
cursor_mysql = conn_mysql.cursor()

# 创建表结构（假设表结构相同）
cursor_mysql.execute("CREATE TABLE IF NOT EXISTS your_table (column1 datatype, column2 datatype, ...)")

# 插入数据
for row in rows:
    cursor_mysql.execute("INSERT INTO your_table (column1, column2, ...) VALUES (%s, %s, ...)", row)

# 提交更改并关闭连接
conn_mysql.commit()
cursor_mysql.close()
conn_mysql.close()
cursor_sql_server.close()
conn_sql_server.close()