MySQL-Insert-Delete-Update-Select
Save Data in DB using Mysql queries.
[{"id":"b2b09f39.2ac5d","type":"inject","z":"5e24a2b8.c12b5c","name":"Go","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":"","x":190,"y":100,"wires":[["9b2cfd89.80b03"]]},{"id":"9b2cfd89.80b03","type":"function","z":"5e24a2b8.c12b5c","name":"INSERT Data","func":"msg.topic = \"INSERT INTO ?? (??) VALUES (?)\";\nmsg.payload = [\"Department\",\"Department_name\",\"test\"];\nreturn msg;","outputs":1,"noerr":0,"x":380,"y":100,"wires":[["4d7282eb.906e7c"]]},{"id":"cbf82508.506aa8","type":"debug","z":"5e24a2b8.c12b5c","name":"","active":true,"console":"false","complete":"false","x":791,"y":232,"wires":[]},{"id":"e4a98c17.08f2d","type":"inject","z":"5e24a2b8.c12b5c","name":"Go","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":188,"y":152,"wires":[["5addf67b.173138"]]},{"id":"5addf67b.173138","type":"function","z":"5e24a2b8.c12b5c","name":"Update Data","func":"msg.topic = \"Update Department Set Department_name = ? where Department_id=?\";\nmsg.payload=['Logistics Managers','3']\nreturn msg;","outputs":1,"noerr":0,"x":367,"y":156,"wires":[["4d7282eb.906e7c"]]},{"id":"e4201ad4.996998","type":"inject","z":"5e24a2b8.c12b5c","name":"Go","topic":"","payload":"warehouse","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":"","x":190,"y":320,"wires":[["be458293.0fb91"]]},{"id":"be458293.0fb91","type":"function","z":"5e24a2b8.c12b5c","name":"SELECT Data","func":"msg.topic = \"SELECT * FROM department WHERE department_name LIKE '%\" + msg.payload + \"%'\";\nreturn msg;","outputs":1,"noerr":0,"x":380,"y":320,"wires":[["4d7282eb.906e7c"]]},{"id":"9c203b7a.d31738","type":"inject","z":"5e24a2b8.c12b5c","name":"INSERT Bind - via JSON","topic":"INSERT INTO test (id,text) VALUES (?, ?)","payload":"[4, \"This is a funny world's end\"]","payloadType":"str","repeat":"","crontab":"","once":false,"x":209,"y":217,"wires":[["404656b9.7048b8"]]},{"id":"404656b9.7048b8","type":"json","z":"5e24a2b8.c12b5c","name":"","x":409,"y":217,"wires":[["4d7282eb.906e7c"]]},{"id":"421f97c2.5607f8","type":"inject","z":"5e24a2b8.c12b5c","name":"Go \"Warehouse\"","topic":"","payload":"%Warehouse%","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":"","x":200,"y":380,"wires":[["778ca316.16ea8c"]]},{"id":"778ca316.16ea8c","type":"function","z":"5e24a2b8.c12b5c","name":"SELECT Data","func":"msg.topic = \"SELECT * FROM Department WHERE Department_Name LIKE ?\";\nmsg.payload = [msg.payload];\nreturn msg;","outputs":1,"noerr":0,"x":400,"y":400,"wires":[["4d7282eb.906e7c"]]},{"id":"632ef9df.2db478","type":"inject","z":"5e24a2b8.c12b5c","name":"Go \"MAnagers\"","topic":"","payload":"%Managers%","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":"","x":200,"y":420,"wires":[["778ca316.16ea8c"]]},{"id":"4d7282eb.906e7c","type":"mysql","z":"5e24a2b8.c12b5c","mydb":"6cf82e37.9a1db","name":"","x":640,"y":160,"wires":[["cbf82508.506aa8"]]},{"id":"88f58b45.552b48","type":"function","z":"5e24a2b8.c12b5c","name":"Delete Bind","func":"msg.topic = \"Delete From department where Department_id = ?\";\nmsg.payload = [ \"6\"];\nreturn msg;","outputs":1,"noerr":0,"x":370,"y":260,"wires":[["4d7282eb.906e7c"]]},{"id":"8be8aa44.6b7868","type":"inject","z":"5e24a2b8.c12b5c","name":"Go","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":190,"y":260,"wires":[["88f58b45.552b48"]]},{"id":"a2cac161.b5ebf","type":"function","z":"5e24a2b8.c12b5c","name":"INSERT Data","func":"msg.topic = \"INSERT INTO department (department_name) VALUES (?)\";\nmsg.payload = [ \"test\"];\nreturn msg;\n\nmsg.topic = \"INSERT INTO ?? (??) VALUES (?)\";\nmsg.payload = [\"Department\",\"Department_name\",\"test\"];\nreturn msg;","outputs":1,"noerr":0,"x":380,"y":40,"wires":[["4d7282eb.906e7c"]]},{"id":"cabc5ca6.c3e37","type":"inject","z":"5e24a2b8.c12b5c","name":"Go","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":190,"y":40,"wires":[["a2cac161.b5ebf"]]},{"id":"6cf82e37.9a1db","type":"MySQLdatabase","z":"","host":"127.0.0.1","port":"3306","db":"sys","tz":""}]
