Here the code:
[
{
"id": "fcb9da7f7a9651c5",
"type": "tab",
"label": "SQL",
"disabled": false,
"info": "",
"env": []
},
{
"id": "80fc3bf2aa84e7d1",
"type": "inject",
"z": "fcb9da7f7a9651c5",
"name": "",
"props": [],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"x": 590,
"y": 220,
"wires": [
[
"3f3657dccbad3463"
]
]
},
{
"id": "3f3657dccbad3463",
"type": "mysql",
"z": "fcb9da7f7a9651c5",
"mydb": "bc82281c113049b7",
"name": "",
"x": 800,
"y": 220,
"wires": [
[
"9b778df266405d0c"
]
]
},
{
"id": "9b778df266405d0c",
"type": "debug",
"z": "fcb9da7f7a9651c5",
"name": "debug 10",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 1000,
"y": 200,
"wires": []
},
{
"id": "bc82281c113049b7",
"type": "MySQLdatabase",
"name": "",
"host": "mariadb.local",
"port": "3306",
"db": "homeassistant",
"tz": "",
"charset": "UTF8",
"credentials": {}
}
]
Try to add msg.topic into the inject node with these value:
SELECT table_schema "homeassistant", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;
.. and then deploy the flow. if it's like me, you're going to have this error pop-up that will appear:

Even if i remove the link between the inject and the sql node, i can't deploy the flow:
