My Sql

Node: mySql · Full type: n8n-nodes-base.mySql · Version: 2.5

Credentials

mySql (alias: @mysql)

CREDENTIAL @mysql = mySql "My My Sql"

Operations

deleteTable

No additional parameters.

executeQuery

No additional parameters.

insert

No additional parameters.

upsert

No additional parameters.

select

No additional parameters.

update

No additional parameters.

Common Parameters

Parameter	Type	Default	Details
table	resourceLocator	{...}	required; modes: list, name

Parameter Details

where children:

values group:

Parameter	Type	Default	Details
column	options	""
condition	options	"equal"	equal, !=, LIKE, >, <, >=, <=, IS NULL, ... (9 total)
value	string	""

options children:

Parameter	Type	Default	Details
connectionTimeoutMillis	number	30
connectionLimit	number	10
queryBatching	options	"single"	single, independently, transaction
queryReplacement	string	""
outputColumns	multiOptions	[]
largeNumbersOutput	options	"text"	numbers, text
decimalNumbers	boolean	false
priority	options	"LOW_PRIORITY"	LOW_PRIORITY, HIGH_PRIORITY
replaceEmptyStrings	boolean	false
selectDistinct	boolean	false
detailedOutput	boolean	false
skipOnConflict	boolean	false

valuesToSend children:

values group:

Parameter	Type	Default	Details
column	options	[]
value	string	""

sort children:

values group:

Parameter	Type	Default	Details
column	options	""
direction	options	"ASC"	ASC, DESC

Example

NODE "mySql" @mysql AS "My Sql" {
  operation: "executeQuery",
  query: {{ $json.query }}
}