How to Connect Node js to MySQL Database and Fetch Data in 5 minutes

[@תמרנידאם]

תותח אלוףףףףףף
ההסבר ממש מעולה ועוזר
תודה!🙏

[@MsamerieJohnson]

For those getting undefined, I used this code to connect to the database
const mysql = require("mysql")
//Create a Database Connection
const con = mysql.createConnection({
host:'localhost',
user:'root',
password:'your_password',
database:'your_databse'
})
con.connect((err) => {
if(err)
{
console.log(err)
}else{
console.log("CONNECTION SUCCESSFUL!")
}
})
// Get The Data From The Table
con.query('select * from your_table', (err, res) =>{
return console.log(res)
})

[@micaelstaubli7653]

you are the best Bro :) thanks

[@LinXiaoChaun]

At [02:39], I was at first thrown off by the destructuring syntax
const {createPool}=require('mysql');
const pool = createPool( { … } ) ;
An equivalent (more pedestrian) alternative would be something like:
const mysql = require('mysql') ;
const pool = mysql.createPool( { …} )

[@nerolifong1824]

short video and to the point. great job

[@phantomak3r477]

Quick and straight to the point.

[@michelsolis6603]

Thanks! And then? When you want to upload proyect to prod? What do I have to do to hide this information?

[@williamdevonshire356]

awesome. finally i can connect the two!!! woo yea!!! Thank you sir :)

[@bryantgarcia998]

Really useful video. By any chance, do you have a follow up video on how to post data to mysql work bench in javascript as well?

[@Sukubus666]

For me it keeps saying 'undefined'. 😭 Could you help out how to fix that issue? I have node.js installed and triple checked if my code looks the same like in video.. 😕

[@CorreaLobo]

Hello Brother! Excellent Video, You just got a sub thank you so much. So simple and understandable. TY ❤❤

[@nimeshpatilvlogs8629]

Do we have to first create table insql

[@assetdev1859]

hey! great video. i have a question, if i want to deploy this website on vercel/heroku what I need to do? our sql data base located in localhost how correctly i understand so can we push it somewhere? something like cloud storage? thanks for the answer :3

[@DiscussedFir6]

Thank you so much for this, great tutorial!

[@KindsonTheTechPro]

Glad it was helpful!

[@wildriftgames1931]

why didn't work on my visual studio code when I'll run in terminal? Pls. help!!

[@Sami_Ljimari]

very useful, thank you for making the video

[@KindsonTheTechPro]

You're welcome 😊

[@_dejvy]

really good tutorial, just one question, how can i default select database name

[@mukkt]

For anyone getting an authentication error:
"npm install mysql2" then change the require statement to "mysql2"

[@saivinaykolla22]

thank u bro

[@goodluckoriuwa1669]

Can uou show how to connect node express app to online MySQL database

[@SITPonrajA]

Hey I have a error on require() function

[@forester1]

Can we query same like php api ?

[@realhistory765]

Thank you bro ❤

[@Dlo2018]

how do i create a node module?

[@rinkijain4517]

Greate sir

[@axsd1489]

Thanks for help

[@KindsonTheTechPro]

Always welcome

[@VarshaSivaramakrishnan]

i applied your code but it just displays undefined what do i do?

[@Maumau369]

is require not defined anymore? i get "ReferenceError: require is not defined"

[@dimitriskosse1727]

thank you bro

[@jasonmiller1076]

mine said undefined

[@unspoken2409]

same

[@leonbou3959]

Hi, i want to store the return of the query in a variable. how can i make that work? When i write const x = (query) and instead of return console.log() just returning the res. It doesn't gave me back the result. Can anyone help me how to get the res returned to store it in a variable?

[@LinXiaoChaun]

In your code, before the call to pool.query, create a variable, say, foo, then assign it the value of res within the function body:
var foo=[] ; pool.query( 'SELECT * FROM apidb.users', (err,res)=>{foo=Array.from(res)} ) ;
The value of foo will now be the result of the mysql query.
To confirm that this code is working, run node in your shell, entering REPL mode, then give it the REPL command '.load database.js'. Node will echo the content of the file database.js followed by the result of running that file.
You will remain in REPL mode: you can give the REPL command "foo", and node will echo its value.
End the session by typing

[@sh44ko58]

@@LinXiaoChaun Why is it not working for me ? Btw i ive coded also something with react so dont be confused ;D
const pool = createPool({
host: "localhost",
user: "root",
password: ""
})
var foo = []
pool.query(`SELECT * FROM appclone.user`, (err, res) => {foo=Array.from(res)} )
res.json({"users": [foo] })
Could you help me ?

[@kashish9220]

"undefined" occur as output of node database.js
please help regarding this

[@saadbinwasi3038]

same did you find solution?

[@nirmalgaur3228]

Maybe your password is not "rootuser".

[@timhoward5]

@@nirmalgaur3228 Nope, because mines did the same thing and I used my password.

[@mikahoy]

It occurs because you haven't select the database where the table reside

[@Pan_Jan_Wroclawski]

try to use mysql2 instead of mysql package

[@yourmoveatheists]

🐐 Thank you!

[@Aman22506]

can this apply in phpmyadmin

[@koggism]

video is blured

[@KindsonTheTechPro]

I guess it is playing in lower resolution in your system, you need to play in a higher resolution

[@forester1]

Greate

[@joeyGunz1-w1r]

I am getting a 504 error when sending data to mysql in nginx

[@rezaeiabazar5324]

ok