NodeJS + MySQL find transaction stored by JSON objects
Budget: $10 – $30 USD
Hi Guys,
Just help me write code Javascript with MySQL to find by where with transaction stored by JSON objects row
This is what data record example:
https://jsoneditoronline.org/#left=cloud.d44dc33dfd23422f8e26a47cd3de1971
This is my database design to save record:
https://ibb.co/Vw28Sm2
This is my database code:
https://pastebin.com/q3ZNDDBh
Result i need:
field "event" will stored by JSON objects so i want to find by where with mtcode which will find one by one but can use any mtcode to find transaction
P.S.:
1) i use this MySQL for my nodejs https://www.npmjs.com/package/mysql
Just help me write code Javascript with MySQL to find by where with transaction stored by JSON objects row
This is what data record example:
https://jsoneditoronline.org/#left=cloud.d44dc33dfd23422f8e26a47cd3de1971
This is my database design to save record:
https://ibb.co/Vw28Sm2
This is my database code:
https://pastebin.com/q3ZNDDBh
Result i need:
field "event" will stored by JSON objects so i want to find by where with mtcode which will find one by one but can use any mtcode to find transaction
P.S.:
1) i use this MySQL for my nodejs https://www.npmjs.com/package/mysql