Save Data in DB using Mysql queries.
-
-
Save MiriamKhalil1994/77c622527567d8d57b5778e53dbc0a78 to your computer and use it in GitHub Desktop.
MySQL-Insert-Delete-Update-Select
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[{"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":""}] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment