https://embedded-workflow-builder.netlify.app/assets/js/0b33f508.6a615af3.js

1"use strict";(self.webpackChunkembedded_workflow_builder_docs=self.webpackChunkembedded_workflow_builder_docs||[]).push([["8397"],{75012(e,n,t){t.r(n),t.d(n,{metadata:()=>s,default:()=>h,frontMatter:()=>a,contentTitle:()=>d,toc:()=>l,assets:()=>o});var s=JSON.parse('{"id":"connectors/mysql","title":"MySQL Connector","description":"Query and manage data in a MySQL Database","source":"@site/docs/connectors/mysql.md","sourceDirName":"connectors","slug":"/connectors/mysql","permalink":"/connectors/mysql","draft":false,"unlisted":false,"tags":[],"version":"current","frontMatter":{"title":"MySQL Connector","sidebar_label":"MySQL","description":"Query and manage data in a MySQL Database"},"sidebar":"docs","previous":{"title":"MQTT","permalink":"/connectors/mqtt"},"next":{"title":"New Relic","permalink":"/connectors/new-relic"}}'),r=t(74848),i=t(28453);let a={title:"MySQL Connector",sidebar_label:"MySQL",description:"Query and manage data in a MySQL Database"},d,o={},l=[{value:"Connections",id:"connections",level:2},{value:"On-Premise Connection",id:"mysql",level:3},{value:"Configure the Connection",id:"configure-the-connection",level:4},{value:"Actions",id:"actions",level:2},{value:"Query Database",id:"query",level:3}];function c(e){let n={a:"a",code:"code",h2:"h2",h3:"h3",h4:"h4",img:"img",li:"li",p:"p",strong:"strong",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",ul:"ul",...(0,i.R)(),...e.components};return(0,r.jsxs)(r.Fragment,{children:[(0,r.jsxs)(n.p,{children:[(0,r.jsx)(n.img,{alt:"MySQL",src:t(82979).A+"#connector-icon",width:"32",height:"32"}),"\n",(0,r.jsx)(n.a,{href:"https://www.mysql.com/",children:"MySQL"})," is a popular relational database system.\nThis component allows you to query a MySQL database."]}),"\n",(0,r.jsx)(n.h2,{id:"connections",children:"Connections"}),"\n",(0,r.jsx)(n.h3,{id:"mysql",children:"On-Premise Connection"}),"\n",(0,r.jsx)(n.p,{children:"Authenticate requests to a MySQL server."}),"\n",(0,r.jsxs)(n.p,{children:["Create a connection of type ",(0,r.jsx)(n.strong,{children:"On-Premise Connection"})," to authenticate with a MySQL server."]}),"\n",(0,r.jsx)(n.h4,{id:"configure-the-connection",children:"Configure the Connection"}),"\n",(0,r.jsxs)(n.ul,{children:["\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Host"}),": The publicly-accessible address of the MySQL server (e.g., ",(0,r.jsx)(n.code,{children:"my-server.example.com"}),")"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Port"}),": The port the database server is exposing (default: ",(0,r.jsx)(n.code,{children:"3306"}),")"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Database"}),": The name of the MySQL database to connect to"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Username"})," (optional): The username for authenticating with the MySQL server"]}),"\n",(0,r.jsxs)(n.li,{children:[(0,r.jsx)(n.strong,{children:"Password"})," (optional): The password for authenticating with the MySQL server"]}),"\n"]}),"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",(0,r.jsxs)(n.table,{children:[(0,r.jsx)(n.thead,{children:(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.th,{children:"Input"}),(0,r.jsx)(n.th,{children:"Comments"}),(0,r.jsx)(n.th,{children:"Default"})]})}),(0,r.jsxs)(n.tbody,{children:[(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Host"}),(0,r.jsx)(n.td,{children:"The publicly-accessible address of the MySQL server."}),(0,r.jsx)(n.td,{children:"my-server.example.com"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Port"}),(0,r.jsx)(n.td,{children:"The port the database server is exposing."}),(0,r.jsx)(n.td,{children:"3306"})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Database"}),(0,r.jsx)(n.td,{children:"The name of the MySQL database to connect to."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Username"}),(0,r.jsx)(n.td,{children:"The username for authenticating with the MySQL server."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Password"}),(0,r.jsx)(n.td,{children:"The password for authenticating with the MySQL server."}),(0,r.jsx)(n.td,{})]})]})]}),"\n",(0,r.jsx)(n.h2,{id:"actions",children:"Actions"}),"\n",(0,r.jsx)(n.h3,{id:"query",children:"Query Database"}),"\n",(0,r.jsx)(n.p,{children:"Executes a query against a MySQL database and returns the results."}),"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n",(0,r.jsxs)(n.table,{children:[(0,r.jsx)(n.thead,{children:(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.th,{children:"Input"}),(0,r.jsx)(n.th,{children:"Comments"}),(0,r.jsx)(n.th,{children:"Default"})]})}),(0,r.jsxs)(n.tbody,{children:[(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Connection"}),(0,r.jsx)(n.td,{children:"The MySQL connection to use."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Query"}),(0,r.jsx)(n.td,{children:"The SQL query to execute against the MySQL server. Use '?' placeholders for parameterized values."}),(0,r.jsxs)(n.td,{children:["SELECT * FROM ",(0,r.jsx)(n.code,{children:"table"})," WHERE ",(0,r.jsx)(n.code,{children:"name"})," = ? AND ",(0,r.jsx)(n.code,{children:"age"})," > ?"]})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Parameters"}),(0,r.jsx)(n.td,{children:"The ordered list of values to bind to '?' placeholders in the query. Use this when the number of parameters is known at design time. Use either Parameters or Reference Parameters, not both."}),(0,r.jsx)(n.td,{})]}),(0,r.jsxs)(n.tr,{children:[(0,r.jsx)(n.td,{children:"Reference Parameters"}),(0,r.jsx)(n.td,{children:"A JSON array of values to bind to '?' placeholders, referenced from a previous step. Use this when the number of parameters is determined at runtime. Use either Parameters or Reference Parameters, not both."}),(0,r.jsx)(n.td,{})]})]})]})]})}function h(e={}){let{wrapper:n}={...(0,i.R)(),...e.components};return n?(0,r.jsx)(n,{...e,children:(0,r.jsx)(c,{...e})}):c(e)}},82979(e,n,t){t.d(n,{A:()=>s});let s="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAACXBIWXMAABcRAAAXEQHKJvM/AAAEwUlEQVRYhe1Wf4gUVRz/7KlhetfOWzII0X4pqRWZQmEUiYGFWHrkHqGZgrB25Gl3O2/m7tQmrT+U23nz3szdepuhlRF0YVD0O8j6o/4oyqB/iiMUrETF253ZvatUmHhvdvd267AkTyr8wBvevHnvfT/v++PzBriM/xFisKyJSCYn4F8By2pQ7RIgpp7mrjh0eyMoX4aBgQk1XhlnElbZQEfmDujMAGVrQB0TaXsz2u3b1bdLFhbdWY90z3XQnfkw7DtBnaeRZmvriI4LwjAKQ5rfqki0iWmgu5siUqwNurNx/ElUXC2NWdlr1Lu

1sCgnqPAOauX98SVjljdNsCWjm4ToCJp8J3WHj64FkOdF0tgKUz66SqoxT20S6Z3EdsYuKZLn0Or0kTH4PdPuxaLxMoCszB7rNR+df7Mqwyu59ii1Ap5tFp/sGNu+aWUcuzR+FziyY3m3lVTFcdEgRomwtKFsAnS2tEqvmSM9U6OxJNaeKP2t4pOvnSZowROyQhYmyhUlU14YDmCC/yXajVMdyOVpW8go1gToroTMPBluFVG5S7Z6xC3FJOMZcafQvtUImqM6EEioFecq0Y0K3V0cDaqwROn9WldQfsjY5EHlqpI/MCISW8YX2gs+1KOEAFDhZXeDk5aIgfUOupqTYF+TugiCp6v4yDNRehnZ7OrDF0bD9+WFs6z+mLhQJ6i1Hz2shtu0RNQRitacucu2zkiAH8058fYFrm+RYySN6SZCjQzyxLnDJi8MeOX3CmtZ4LpfYdDaXOBytDGOWhQblkZQMQVrMg8G+g8mPQefNak5Xrw2DnwBl+6NLxslIAtOkZzo8tnLnhrlhLn4q7yUeqRA6YmHyr32JoyO9pEWZAWIjHhk8kyWtQ0xbEwjyZdUDdbekzpaC2h/AdF+BKfZhnTUZpvseDCcDyg5hq3sDurMFFbsuMS+2NXscqZ+mnHWnPhe4idAXZKdMPJ83zS66mh9kGudUrASCvF1yieM72uOBIF/VERiNhy1r832YvBmG+zVM0YpOL4s0awF1BqOQiE9huJtgiBZQ/lFl6RDTHiq65OeSm/j8FIsvCQQZCvoa51bDJMibJY8wX2hrfU5UCMIQDapKLDREITX4BujsQ5UYhvgWpjgO02sGte8DZSfUTibvhMHfgsH3wnB3yKGFqZQqoR92kfhvWXLyXC7RNeyRo4HQVlQI/NJHvjmTJalCFIIvMCa6etPozn4S9bMvYXsuRHv7lTC9xejO+rD2T0a7PQvUOQ7THUTn3lnyBEMi0ZZ340uGPfLEsKeVTu6OLyh55MBIH/n+tNO0qOjGd5Q8ckS6+1yOtJ7tJz8WBGnJO/GVw3sS0/NOfP7pDJkB0Mxy9Qcj0ZF5QEmlxBbnZlDWDys3pUz0CLp7D8huLrdwUpEntvicHAyE9k5eJFapmOeuvdp3iFfg2rs+Jx8Hggzmvfhi3yGLfE5eD7j2apFr/QVx1U3SU77TdNfYXolKL8pSg92ilIuyw+jIzKgTlRqouJaTqyJIBUEezPOoUmTMxzYUhqMlUduvXCCU3QvKbJjO9bXGleRKbZCGByIpVv2yLNeqYjXpyi06X5SM+NuQhsc4+fmXjBr8p//3Ey/U+GX8Z/A7vVMgqelEgBsAAAAASUVORK5CYII="},28453(e,n,t){t.d(n,{R:()=>a,x:()=>d});var s=t(96540);let r={},i=s.createContext(r);function a(e){let n=s.useContext(i);return s.useMemo(function(){return"function"==typeof e?e(n):{...n,...e}},[n,e])}function d(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(r):e.components||r:a(e.components),s.createElement(i.Provider,{value:n},e.children)}}}]);