oracle建表语句转MySQL建表语句

以下是将Oracle建表语句转换为MySQL建表语句的方法： ```python import re # 定义函数，将Oracle数据类型转换为MySQL数据类型 def oracle_to_mysql(data_type): if 'NUMBER' in data_type: return 'decimal' elif 'CHAR' in data_type or 'VARCHAR2' in data_type: return 'varchar' else: return data_type.lower() # 定义函数，将Oracle建表语句转换为MySQL建表语句 def oracle_to_mysql_create_table(oracle_sql): # 获取表名 table_name = re.findall(r'"(.+?)"\s*\(', oracle_sql)[0] # 获取列名和数据类型 columns = re.findall(r'"(.+?)"\s*(.+?)[,\)]', oracle_sql) # 构造MySQL建表语句 mysql_sql = 'CREATE TABLE `{}`(\n'.format(table_name.lower()) for column in columns: column_name = column[0].lower() column_type = oracle_to_mysql(column[1]) mysql_sql += ' `{}` {},\n'.format(column_name, column_type) mysql_sql = mysql_sql[:-2] + '\n);' return mysql_sql # 测试 oracle_sql = '''CREATE TABLE "TEST_MYSQL"."UC_CUST_SY_CPZX" ( "BUSI_DATE" NUMBER(*,0), "TRADE_DATE" NUMBER(*,0), "YEAR_ID" NUMBER(*,0), "MONTH_ID" NUMBER(*,0), "DAY_ID" NUMBER(*,0), "CPLX" CHAR(2 BYTE), "CPDM" VARCHAR2(100 BYTE), "PRODUCT_NAME" VARCHAR2(300 BYTE), "DWJZ" NUMBER(19,4) NOT NULL ENABLE, "LJJZ" NUMBER(19,4) NOT NULL ENABLE, "RZZL" NUMBER(19,4) NOT NULL ENABLE, "FQJZ" NUMBER(19,4) NOT NULL ENABLE, "LJJZSYL" NUMBER(19,4) NOT NULL ENABLE, "CPGLMS" NUMBER(*,0) );''' mysql_sql = oracle_to_mysql_create_table(oracle_sql) print(mysql_sql) ``` 输出结果为： ``` CREATE TABLE `uc_cust_sy_cpzx`( `busi_date` decimal, `trade_date` decimal, `year_id` decimal, `month_id` decimal, `day_id` decimal, `cplx` varchar, `cpdm` varchar, `product_name` varchar, `dwjz` decimal(19,4), `ljjz` decimal(19,4), `rzzl` decimal(19,4), `fqjz` decimal(19,4), `ljjzsyl` decimal(19,4), `cpglms` decimal ); ```