plsql导出表到mysql数据库表

-- 示例：将 Oracle 的 NUMBER 类型转换为 MySQL 的 DECIMAL 类型
CREATE TABLE new_table (
    id DECIMAL(10, 2),
    name VARCHAR(255)
);

-- 设置 MySQL 的字符集为 utf8mb4
ALTER DATABASE your_database CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER TABLE your_table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 使用批量插入提高导入速度
LOAD DATA INFILE 'path_to_your_file' INTO TABLE your_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

CREATE TABLE employees (
    id NUMBER,
    name VARCHAR2(100),
    salary NUMBER
);

SELECT * INTO OUTFILE '/path/to/exported_data.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM employees;

CREATE TABLE employees (
    id DECIMAL(10, 2),
    name VARCHAR(100),
    salary DECIMAL(10, 2)
);

LOAD DATA INFILE '/path/to/exported_data.csv'
INTO TABLE employees
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';