This tool provides a conversion tool for automatically converting multiple databases from SQL to CSV code, and supports major databases such as MySQL, PostgreSQL, and Oracle. This tool not only automatically parses annotations, but also adapts to multiple database environments to ensure efficient and accurate data export processes. By simplifying the data processing process and greatly improving work efficiency, it is an ideal choice for developers in multi-database management and data migration.
使用说明
Function introduction
- Support SQL to csv table creation for multiple databases, including (pg, oracle, mysql) and other databases; table creation statements, table creation statements, table creation statements(Say the important three times)
- When converting sql, you need to confirm whether you need to switch processing types. Three processing methods are temporarily supported (normal, postgresql, oracle). Default: normal.
Example
CREATE TABLE if not exists user (
id int NOT NULL AUTO_INCREMENT,
name varchar(10) NOT NULL COMMENT 'name',
gender tinyint NOT NULL DEFAULT 0 COMMENT 'Gender 0-Unknown 1-Male 2-Femal',
age int NOT NULL COMMENT 'age',
created_date datetime DEFAULT CURRENT_TIMESTAMP,
updated_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);