At 11:10 I felt a CATHARTIC feeling, thank you mate!! That was the point when I understood the whole meaning of "API" and "backend". :) I started my learning path with courses on frontend, how to create simple webpages (HTML, CSS, JavaScript basics), then I learned the SQL queries of MS SQL and MySQL, and now I could connect the two with your help, thanks a lot!!
Amazing thank you , I'm used to use mysql for my project and when i saw for node everyone use mongodb , i learn mongodb but I'm really happy to see i tutorial for node and mysql so thank you :)
Good video. Just to make life easier at the start when you're creating a package.json file. If you type "npm init --yes", a file will be created without asking you any questions.
For anyone looking to copy and paste some SQL statements with some sample data for insert and just wanted to save some typing: use EmployeeDB; create table `employee` ( `EmpID` int(11) not null auto_increment, `Name` varchar(45) default null, `EmpCode` varchar(45) default null, `Salary` int(11) default null, primary key (`EmpID`) ) engine=InnoDB auto_increment=0 default charset=utf8mb4; select * from employee; lock tables `employee` write; insert into `employee` values (1, 'Tommy Eatsheet', 'EMP90', 265400), (2, 'Jess Fukenson', 'EMP92', 50000),(3, 'Bob Knobhead', 'EMP95', 10000),(4, 'Dick knogginson', 'EMP96', 90000);
in 22:24 when you made a variable and called it SQL you add '@' behind each of the request data like 'set @empId = ?' I want to know why? I can't just do the POST!
For those who get this : ER_NOT_SUPPORTED_AUTH_MODE after doing node index.js this is error is mentioning when you install sql server you selected"strong authentication", but you set a weak password. You need to reset strong password or need to choose legacy authentication method. Follow these steps to choose legacy authentication method You installed mysql server using "mysql installer" 1)open -> "mysql intsaller" 2)press reconfig mysql server 3)select left side "authentication method tab" 4)select radio button -->use legacy authentication method 5)now stop and restart the db and it should work
This was perfect thanks a lot. Just in case someone is using this today or in the near future, I had an error on workbench I changed the last line of code to this ENGINE=iNNOdb AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 and it worked just fine It was the only issue I had
Awesome tutorial! Just had one question regarding the mysqlconnection. I noticed that you never actively closed your connection to the database. Will that cause issues in production, or are there underlying features within the packages used that help manage the connections as clients connect to your application?
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:\Users w888\Desktop\project\package.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:\Users w888\Desktop\project\index.js
I got this error message: { "code": "ER_NOT_SUPPORTED_AUTH_MODE", "errno": 1251, "sqlMessage": "Client does not support authentication protocol requested by server; consider upgrading MySQL client", "sqlState": "08004", "fatal": true }
getting this error: dbconnection failed: { "code": "ER_NOT_SUPPORTED_AUTH_MODE", "errno": 1251, "sqlMessage": "Client does not support authentication protocol requested by server; consider upgrading MySQL client", "sqlState": "08004", "fatal": true }
hello codeAffection can you make the same thing for nodejs+postgresql the connection,how to insert,update,delete using the post,get,put http request can you??
IF U CREATE STORED PROCEDURE IN MYSQL USING XAMPP, THEN IST LINE IS CREATE PROCEDURE PROCEDURENAME( PROCEDURENAME IS NOT BETWEEN ANY SEMICOLONS AND USE DELIMETER AS //
goo.gl/RFY5C2 : Subscribe to CodAffection
goo.gl/bPcyXW : Buy me a Coffee
How can using MySQL and MS-SQL on the same machine
Hi, have you ever tried building the query into a middleware? I'm having issues exporting my response. Any tips?
WHAT IS THIS ACCENT?
Man, very thanks for this video
[04:40] : index.js
[07:46] : express
[18:24] : Insert an employees (Store procedure)
[26:05] : Update an employees
At 11:10 I felt a CATHARTIC feeling, thank you mate!!
That was the point when I understood the whole meaning of "API" and "backend". :)
I started my learning path with courses on frontend, how to create simple webpages (HTML, CSS, JavaScript basics),
then I learned the SQL queries of MS SQL and MySQL,
and now I could connect the two with your help, thanks a lot!!
Wow...simply wow. Took a bit for me to get everything installed and to work out my syntax errors but your tutorial is flawless. Thanks!
Thank you so much, I was searching for this from 7-8 hours but nothing found , Now I have done it in one try after this tutorial. Again thanks
Glad you found this helpful.
Amazing thank you , I'm used to use mysql for my project and when i saw for node everyone use mongodb , i learn mongodb but I'm really happy to see i tutorial for node and mysql so thank you :)
Hey yukina! Do you know of a video like this, but with mongodb instead of MySQL ? That would be really helpful! Thanks :)
Congrats, amazing tutorial, I imagined Node.js was a monster.
Good video. Just to make life easier at the start when you're creating a package.json file. If you type "npm init --yes", a file will be created without asking you any questions.
it can also work with npm init -y ..
awesome, without --yes it was giving error module not found. thanks for help :)
Thanks for the info.
Thanks man! It really helped... I was searching on the internet since a long...finally found something useful...Nice explanation.
For anyone looking to copy and paste some SQL statements with some sample data for insert and just wanted to save some typing:
use EmployeeDB;
create table `employee` (
`EmpID` int(11) not null auto_increment,
`Name` varchar(45) default null,
`EmpCode` varchar(45) default null,
`Salary` int(11) default null,
primary key (`EmpID`)
) engine=InnoDB auto_increment=0 default charset=utf8mb4;
select * from employee;
lock tables `employee` write;
insert into `employee` values (1, 'Tommy Eatsheet', 'EMP90', 265400), (2, 'Jess Fukenson', 'EMP92', 50000),(3, 'Bob Knobhead', 'EMP95', 10000),(4, 'Dick knogginson', 'EMP96', 90000);
Thank you.
i was literally searching this in comments ,thankyou somuch.
Thanks you i was looking for this entire RUclips and here i get my solution love from india😇
This is exactly what I was looking for. Thanks !
thank you so much, i was searching it for 1 week finally i got from this video it was excellent
Glad to hear that
Thanks sir I watched lots of video but that didn't worked for me but your video worked properly for thanks for such a great tutorial
Glad to hear that
Thankyou so much again for such a wonderful video that make me understand Node jS API and I can say I know Node js.
This is superb guidance tutorial for beginners
Glad you think so!
Started just in the beginning, I know that this is what I was looking for. Thanks
glad it helped.
Thank you very much for the tutorial. It is the great tutorial I have met so far.
excelent, Brazil here, thx for help!
Great!!!! easy explaination and simple script usage
thank you so much, amazing tutorial here!
it is very helpful and easy way to understand api thanks a lot
17:28 Did you mentioned 'ForceMan'? Why did you use it?
it was very helpful ,thankyou
Exactly what I needed, Thanks a lot :) Just a tip for those who are facing problem in inserting data to the database table - make EmpID AUTO_INCREMENT
but in my code auto increment is not working I don't know why
very helpful tutorial.
@raddy 's tutorial is awesome
Thank you man, a very clear explanation!
tq....exactly wat i needed ....great tutorial
It was the best tutorial I ever watched about GET,POST,PUT and DELETE
Thanks for this amazing clear tutorial
Glad you found the video helpful.
thanks man.. what a great video.. easy and sharp... you saved my day. I appreciate your work.
Glad you found the video helpful.
Thank You so much made my day :)
Thank you so much brother. This is exactly what I wanted. 😁
Most welcome 😊
Superb explanation Sir.
Exactly what I needed, great tutorial!
glad you found the video helpful.
The video is very useful for me, thanks for your excellent job.
Very helpful video. Thank you so much!
glad you found the video helpful.
Thank you very much sir. Excellent tutorial.
glad you found the video helpful.
Very Nice, Very Easy
Indian coding YTbers are carrying us through quarantine projects/assignments
Thank you so much for this tutorial, it's been very helpful
Glad you found this video helpful.
Thank you very much for making this :)
No problem 😊, let me know if you have any suggestion for upcoming tutorial ?
in 22:24 when you made a variable and called it SQL you add '@' behind each of the request data like 'set @empId = ?' I want to know why?
I can't just do the POST!
Thank you so much
For those who get this : ER_NOT_SUPPORTED_AUTH_MODE
after doing node index.js
this is error is mentioning when you install sql server you selected"strong authentication", but you set a weak password. You need to reset strong password or need to choose legacy authentication method.
Follow these steps to choose legacy authentication method
You installed mysql server using "mysql installer"
1)open -> "mysql intsaller"
2)press reconfig mysql server
3)select left side "authentication method tab"
4)select radio button -->use legacy authentication method
5)now stop and restart the db
and it should work
thanks buddy
thank you
love your tuts..... plz make a tutorial on "WPF login(hashed) MVVM and EF7 CRUD application with online mysql database "
NIce Tutorial. Its very helpfull to me.
Thanks for the comment.
You can also use MySQL server of XAMPP
Thanks a lot for nice video tutorial
You are a awesome. your video really helpful for me. thank you ..
Thanks, let me know if you have any video suggestion related to node js.
How to you run index.js file in command prompt. Here i can not run node index.js file.
literally killed me with your joke 7:25
The table creation data:
CREATE TABLE `employee` (
`EmpId` INT(11) NOT NULL AUTO_INCREMENT,
`Name` VARCHAR(45) DEFAULT NULL,
`EmpCode` VARCHAR(45) DEFAULT NULL,
`Salary` INT(11) DEFAULT NULL,
PRIMARY KEY (`EmpId`))
ENGINE = InnoDB AUTO_INCREMENT=0;
you saved me
I am getting the message DB connection succeded... but when passing /employees I am not seeing the table record
Same here... Found any solution?
any solution?
same here
@@junaidqureshi9376 can u get any solution on these??
awesome clean video I am from a Java background, this has been successfully helpful.
Glad you found the video helpful.
very very good. Congratulations
Very helpful video.Thank you so much.Keep going on -:)
glad you found the video helpful.
Awesome 👏
This was perfect thanks a lot. Just in case someone is using this today or in the near future, I had an error on workbench
I changed the last line of code to this
ENGINE=iNNOdb AUTO_INCREMENT=0 DEFAULT CHARSET=utf8
and it worked just fine
It was the only issue I had
TY
Thanks man you saved me
Just Awesome. Thanks Bro..
Awesome tutorial!
Just had one question regarding the mysqlconnection.
I noticed that you never actively closed your connection to the database. Will that cause issues in production, or are there underlying features within the packages used that help manage the connections as clients connect to your application?
great tutorial!
nice work...thnaks
Great tutorial.
Integer display width is deprecated. You don't need it, you just need 'int'.
Thank you so much!!!!
thankyou, may i ask what is difference between put and post
love u bro
Thank you bro. You make easy to understand.
How to write procedure in mysql(phpmyadmin)
Why did you use stored procedure instead of normal query, is there any reason ?
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:\Users
w888\Desktop\project\package.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:\Users
w888\Desktop\project\index.js
somebody plz tell how to connect this nodejs to angular for crup operations plzzzzzzz
Unable to fetch data from database. But db is connected
same! did you resolve it?
Thank you!
thanks for watching.
Nice content ! 👧
What online cloud database do we use to migrate/deploy the mysql workbench database?
can you tell me how can i use this to create a login feature on my HTML website using nodejs and mysqlworkbench
my post method is not working it shows 200 requests but does not store data in MySQL plz help
Great ❤️
Thank you so much, it is help me a lot, how to display data in html table?
Very good video!!!!
how can I link the routes with a front end user interface whereby my user can fetch all the data by clicking on a button?
By API
where can I find that copy paste query? please let me know.
i cant connect because the hostname , where you find hostname ?
thank you sir !
I'm getting error with rows[0]..It says "not able to read properties of undefined)
I got this error message: {
"code": "ER_NOT_SUPPORTED_AUTH_MODE",
"errno": 1251,
"sqlMessage": "Client does not support authentication protocol requested by server; consider upgrading MySQL client",
"sqlState": "08004",
"fatal": true
}
install mysql2
if i refactor my code into multiple files eg. routes etc do i need to create mysqlConnection object for every page? please reply thank in advance :)
🖤🙌🙌 greatful
getting this error:
dbconnection failed: {
"code": "ER_NOT_SUPPORTED_AUTH_MODE",
"errno": 1251,
"sqlMessage": "Client does not support authentication protocol requested by server; consider upgrading MySQL client",
"sqlState": "08004",
"fatal": true
}
dude
you are awesome
greetings from chille
PD: smoke weed
the weed loves you if you love her
sir, you didn't show how to make the model with for example sequelize?
hello codeAffection can you make the same thing for nodejs+postgresql the connection,how to insert,update,delete using the post,get,put http request can you??
is this use xampp for the mysql run?
yes
how i add response codes?
I am getting error saying 1251 client does not support authentication protocol requested by server pls help
IF U CREATE STORED PROCEDURE IN MYSQL USING XAMPP,
THEN IST LINE IS
CREATE PROCEDURE PROCEDURENAME(
PROCEDURENAME IS NOT BETWEEN ANY SEMICOLONS
AND USE DELIMETER AS //
How to create this procedure in Ubuntu terminal??