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

[@williamdevonshire356]

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

[@nerolifong1824]

short video and to the point. great job

[@phantomak3r477]

Quick and straight to the point.

[@CorreaLobo]

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

[@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( { …} )

[@DiscussedFir6]

Thank you so much for this, great tutorial!

[@KindsonTheTechPro]

Glad it was helpful!

[@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.. 😕

[@michelsolis6603]

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

[@Sami_Ljimari]

very useful, thank you for making the video

[@KindsonTheTechPro]

You're welcome 😊

[@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

[@axsd1489]

Thanks for help

[@KindsonTheTechPro]

Always welcome

[@_dejvy]

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

[@rinkijain4517]

Greate sir

[@wildriftgames1931]

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

[@dimitriskosse1727]

thank you bro

[@nimeshpatilvlogs8629]

Do we have to first create table insql

[@goodluckoriuwa1669]

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

[@realhistory765]

Thank you bro ❤

[@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 ?

[@forester1]

Can we query same like php api ?

[@SITPonrajA]

Hey I have a error on require() function

[@Dlo2018]

how do i create a node module?

[@VarshaSivaramakrishnan]

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

[@mukkt]

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

[@saivinaykolla22]

thank u bro

[@Maumau369]

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

[@jasonmiller1076]

mine said undefined

[@unspoken2409]

same

[@yourmoveatheists]

🐐 Thank you!

[@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

[@Aman22506]

can this apply in phpmyadmin

[@forester1]

Greate

[@joeyGunz1-w1r]

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

[@rezaeiabazar5324]

ok

[@koggism]

video is blured

[@KindsonTheTechPro]

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