38. Node JS | API | MYSQL | CRUD | JSON | Angular (Tamil)

Explanation: NodeJS code to connect MYSQL with CRUD operation. DB: Stored Procedure, Table structure explaining. NodeJS: Routes, Controller, Service & DB Config coding explaining Nodejs API / REST API testing via Postman tool. ----------------------------------------------------------- Nodejs - API: application Step 1: Create a folder: myfirstapi open that folder in VS Code. Step 2: In Terminal type npm init and hit enter create starting file name: index.js npm install --save express npm install --save cors npm install --save -g nodemon --------------------------------------------------------------- NodeJS API - MSSQL : https://youtu.be/_czwZpFscEE NodeJS API - MYSQL : https://youtu.be/FZg9Pm6a7kA --------------------------------------------------------------- //1) Insert: //localhost:4000/api/book // { // "ActionFlag": "INSUPD", // "Data": { // "BookId": 0, // "BookName": "Thayumanavan", // "Author": "Bala", // "IsActive": 1 // } // } //2) Update: // { // "ActionFlag": "INSUPD", // "Data": { // "BookId": 101, // "BookName": "Thayumanavan", // "Author": "Balakumaran", // "IsActive": 1 // } // } //3) getAllData (GET) //localhost:4000/api/book //4) getDataById (GET) //localhost:4000/api/book/101 //5) deleteDataById (DELETE) //localhost:4000/api/book // { // "ActionFlag": "DELETE", // "Data": { // "BookId": 103 // } // } -------------------------------------------------------------- PlayList: (MEAN Stack Guide) https://www.youtube.com/playlist?list=PL0YIgTrUMXlhUDCkxGaQA741Mf3eYjuft PlayList: (Angular Guide) https://www.youtube.com/playlist?list=PL0YIgTrUMXlhnQCc19_zKmsD7h9d7_SpD PlayList: (Real-Time Project Design) https://www.youtube.com/playlist?list=PL0YIgTrUMXlgC9J3jq_KJSrVaSKTkcQPB Go to website (www.vapstudent.in) then click on "Blog" for CLI commands