nodes/generated

Interface MySqlV2NodeParameters

Source
interface MySqlV2NodeParameters {
    columnToMatchOn?: string;
    combineConditions?: "AND" | "OR";
    dataMode?: "autoMapInputData" | "defineBelow";
    deleteCommand?: "delete" | "truncate" | "drop";
    limit?: number;
    operation?:
        | "update"
        | "upsert"
        | "executeQuery"
        | "insert"
        | "select"
        | "deleteTable";
    options?: {
        connectionLimit?: number;
        connectionTimeoutMillis?: number;
        decimalNumbers?: boolean;
        detailedOutput?: boolean;
        largeNumbersOutput?: "text"
        | "numbers";
        outputColumns?: unknown[];
        priority?: "LOW_PRIORITY" | "HIGH_PRIORITY";
        queryBatching?:
            | "single"
            | "independently"
            | "transaction";
        queryReplacement?: string;
        replaceEmptyStrings?: boolean;
        selectDistinct?: boolean;
        skipOnConflict?: boolean;
    };
    query?: string;
    returnAll?: boolean;
    sort?: {
        values: {
            column?: string;
            direction?: "ASC"
            | "DESC";
        }[];
    };
    table?: { mode: "list"
    | "name"; value: string };
    valuesToSend?: {
        values: { column?: string; value?: string }[];
    };
    valueToMatchOn?: string;
    where?: {
        values: {
            column?: string;
            condition?: | "equal"
            | "!="
            | "<"
            | "<="
            | ">"
            | ">="
            | "IS NOT NULL"
            | "IS NULL"
            | "LIKE";
            value?: string;
        }[];
    };
}

Properties§

Source§

readonly columnToMatchOn?: string

Choose from the list, or specify an ID using an expression Type options: {"loadOptionsMethod":"getColumns","loadOptionsDependsOn":["schema.value","table.value"]}

Source§

readonly combineConditions?: "AND" | "OR"

How to combine the conditions defined in "Select Rows": AND requires all conditions to be true, OR requires at least one condition to be true Default: "AND"

Source§

readonly dataMode?: "autoMapInputData" | "defineBelow"

Whether to map node input properties and the table data automatically or manually Default: "autoMapInputData"

Source§

readonly deleteCommand?: "delete" | "truncate" | "drop"

Default: "truncate"

Source§

readonly limit?: number

Max number of results to return Default: 50 Type options: {"minValue":1}

Source§

readonly operation?:
    | "update"
    | "upsert"
    | "executeQuery"
    | "insert"
    | "select"
    | "deleteTable"

Default: "insert"

Source§

readonly options?: {
    connectionLimit?: number;
    connectionTimeoutMillis?: number;
    decimalNumbers?: boolean;
    detailedOutput?: boolean;
    largeNumbersOutput?: "text" | "numbers";
    outputColumns?: unknown[];
    priority?: "LOW_PRIORITY" | "HIGH_PRIORITY";
    queryBatching?:
        | "single"
        | "independently"
        | "transaction";
    queryReplacement?: string;
    replaceEmptyStrings?: boolean;
    selectDistinct?: boolean;
    skipOnConflict?: boolean;
}

Default: {}

Source§

readonly query?: string

The SQL query to execute. You can use n8n expressions and $1, $2, $3, etc to refer to the 'Query Parameters' set in options below. Type options: {"editor":"sqlEditor","sqlDialect":"MySQL"}

Source§

readonly returnAll?: boolean

Whether to return all results or only up to a given limit

Source§

readonly sort?: {
    values: {
        column?: string;
        direction?: "ASC" | "DESC";
    }[];
}

Default: {} Type options: {"multipleValues":true}

Source§

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

The table you want to work on Default: {"mode":"list","value":""}

Source§

readonly valuesToSend?: { values: { column?: string; value?: string }[] }

Default: {} Type options: {"multipleValueButtonText":"Add Value","multipleValues":true}

Source§

readonly valueToMatchOn?: string

Rows with a value in the specified "Column to Match On" that corresponds to the value in this field will be updated

Source§

readonly where?: {
    values: {
        column?: string;
        condition?:
            | "equal"
            | "!="
            | "<"
            | "<="
            | ">"
            | ">="
            | "IS NOT NULL"
            | "IS NULL"
            | "LIKE";
        value?: string;
    }[];
}

If not set, all rows will be selected Default: {} Type options: {"multipleValues":true}