【the waiter】announcement:
Sql to csv
| | |
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)
);