GO Online Toolset
home
search
feedback

Sql to dml
3541  |   |   |  10

Function introduction

  1. Support the conversion of tables from sql to dml for multiple databases, including (pg, oracle, mysql) and other databases; table creation statements, table creation statements, table creation statements(Say the important three times)
  2. 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.
  3. Support custom filtering of unnecessary fields. Multiple fields are separated by ,

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)
);

After insert processing

INSERT INTO user (name,gender,age,created_date,updated_date) VALUES (?,?,?,?,?)

After update processing

UPDATE user SET name=?, gender=?, age=?, created_date=?, updated_date=? WHERE id=?

After select processing

SELECT id,name,gender,age,created_date,updated_date FROM user WHERE id=?