nodes/generated

Interface MySqlV1NodeParameters

Source
interface MySqlV1NodeParameters {
    columns?: string;
    operation?: "update" | "executeQuery" | "insert";
    options?: {
        ignore?: boolean;
        priority?: "LOW_PRIORITY" | "HIGH_PRIORITY";
    };
    query?: string;
    table?: { mode: "list"
    | "name"; value: string };
    updateKey?: string;
}

Properties§

Source§

readonly columns?: string

Comma-separated list of the properties which should used as columns for the new rows

Source§

readonly operation?: "update" | "executeQuery" | "insert"

Default: "insert"

Source§

readonly options?: {
    ignore?: boolean;
    priority?: "LOW_PRIORITY" | "HIGH_PRIORITY";
}

Modifiers for INSERT statement Default: {}

Source§

readonly query?: string

The SQL query to execute Type options: {"editor":"sqlEditor","sqlDialect":"MySQL"}

Source§

readonly table?: { mode: "list" | "name"; value: string }

Name of the table in which to insert data to Default: {"mode":"list","value":""}

Source§

readonly updateKey?: string

Name of the property which decides which rows in the database should be updated. Normally that would be "id". Default: "id"