Node.js + MySQL CRUD – GET,POST,PUT and DELETE




MySQL CRUD Operations in Node.js application.

In this tutorial, we’ll discuss how to implement crud operation insert update delete and view all in node.js with MySQL database.

Content Discussed :
– How to Connect MySQL DB from Node.js
– Execute MySQL Query From Node.js
– Use of MySQL Store Procedure in Node.js.

๐Ÿ“– Best Node.JS Book from Amazon (Affiliate) :
โžค http://geni.us/UvK8B

Download Project From :
โžค https://goo.gl/3JKBNM

โ˜• Buy me a Coffee (Channel Support through Donation)
โžค https://goo.gl/bPcyXW

Subscribe to this channel Link to this video
โžค https://goo.gl/RFY5C2 โžค http://bit.ly/31KwgeY

________________ ๐ŸŒ€ Related Links __________________
https://goo.gl/T9Nb8r : Angular CRUD with Web API
https://goo.gl/wp17ta : Angular User Registration With Web API
https://goo.gl/4gDFfC : Angular Login Logout With Web API
https://goo.gl/ySUFf8 : Similar Mvc Tutorials

________________ ๐ŸŒŸ About this Channel ______________
CodAffection – [ New videos every Monday at 12:30 PM UTC. ].
This channel is all about teaching and motivating software developers to build applications/ websites in various technologies/ programming languages like Angular, NodeJS, Asp.Net, C#, JavaScript, SQL, Python, etc.

________________ ๐Ÿ”— Social Media Links ______________
Blog : http://www.codaffection.com
Facebook : https://www.facebook.com/codaffection
Twitter : https://twitter.com/codaffection
Youtube : https://youtube.com/codaffection

________________ ๐Ÿ“š Most Recommended Books _______
Code Complete(2nd Edition) : https://geni.us/s6AK9t
The Art of Computer Programming : https://geni.us/Ko4H8m
Clean Code : https://geni.us/Jf9EBTB
Design Patterns : https://geni.us/OMPP
The Pragmatic Programmer : https://geni.us/8UM9F

________________ ๐Ÿ’ฐ Purchase for Developers _________
๐Ÿ’ป Laptops
MacBook Air : https://geni.us/fHZzRiB
Dell XPS 9570 : https://geni.us/rYB6
ASUS ZenBook 13 : https://geni.us/LDKE
Lenovo Ideapad : https://geni.us/Mwvg2
โŒจ๏ธ Keyboard : Das 4 Professional : https://geni.us/hkAdzi
๐Ÿ–ฑ๏ธ Mouse : VicTsing : https://geni.us/tjIM48M
๐ŸŽง Headphone : Mpow 059 Bluetooth : https://geni.us/wAPDmP

________________ ๐ŸŽฌ All Playlist _______________________
http://bit.ly/2KQN9xF : Angular
http://bit.ly/30fPDMg : Asp.Net Core
https://goo.gl/viJcFs : Node JS
https://goo.gl/gvjUJ7 : Asp.Net MVC
https://goo.gl/itVayJ : Web API
https://goo.gl/YJPPAH : MEAN Stack
https://goo.gl/s1zJxo : C# Tutorial
https://goo.gl/GXC2aJ : Asp.Net WebForm
https://goo.gl/vHS9Hd : C# WinForm
https://goo.gl/MLYS9e : MS SQL
https://goo.gl/5Vou7t : Crystal Report
https://goo.gl/EPZ69B : Common C# Excercises
https://goo.gl/qEWJCs : CG Exercises in C Program

#NodeJS #CodAffection #CodAffectionNodeJS

Original source


26 responses to “Node.js + MySQL CRUD – GET,POST,PUT and DELETE”

  1. im getting the below Please help me to solve this
    could not able to get DB Connection.

    F:workspace-angularProject>node index.js

    DB Connection failed

    Error:{

    "code": "ER_ACCESS_DENIED_ERROR",

    "errno": 1045,

    "sqlMessage": "Access denied for user 'root'@'localhost' (using password: YES)",

    "sqlState": "28000",

    "fatal": true

    }

    (node:492) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.

  2. so how do i reopen the workspace when it shows me this?

    [Info – 8:26:41 PM] ESLint server stopped.

    [Info – 8:26:42 PM] ESLint server running in node v10.11.0

    [Info – 8:26:42 PM] ESLint server is running.

    [Info – 8:26:45 PM]

    Failed to load the ESLint library for the document c:Usersrw888Desktopprojectpackage.json

    To use ESLint please install eslint by running npm install eslint in the workspace folder project

    or globally using 'npm install -g eslint'. You need to reopen the workspace after installing eslint.

    If you are using yarn or pnpm instead of npm set the setting `eslint.packageManager` to either `yarn` or `pnpm`

    Alternatively you can disable ESLint for the workspace folder project by executing the 'Disable ESLint' command.

    [Info – 8:26:45 PM]

    Failed to load the ESLint library for the document c:Usersrw888Desktopprojectindex.js

  3. Excellent!. Concise, precise, direct and accurate. I tried mysql v8.0 initially. It threw error about authentication/authorization. Changed to mysql 5.6 and then everything went fine. Can you show how to work with mysql v8.0, the latest? Thanks.

  4. Hi,
    I'm getting the following error while trying to connect db :
    DB connection failed
    errro : {
    "code": "ER_ACCESS_DENIED_ERROR",
    "errno": 1045,
    "sqlMessage": "Access denied for user 'root'@'localhost' (using password: YES)",
    "sqlState": "28000",
    "fatal": true
    }

  5. I am getting the error message after insert query:
    I have table name LSMD

    code: 'ER_NO_SUCH_TABLE',
    errno: 1146,
    sqlMessage: 'Table 'LSMD.employee' doesn't exist',
    sqlState: '42S02',
    index: 4,
    sql:
    'SET @EmpID = 0;SET @Name = 'Waheed Ali';SET @EmpCode = 'EMP95';SET @Salary = 53210; CALL EmployeeAddorEdit(@EmpID,@Name,@EmpCode,@Salary);' }

Leave a Reply