Build restful API with MySQL and NodeJS

Even though this tutorial is about building restful API with MySQL, what I really want you guys to get out of this is understanding that once you know one SQL language, it can easily be translated to other SQL language. Toward the end, I show you guys how to use the SQL MERN stack (MySql, Express, ReactJS, NodeJS) by simply taking the same react todo list I made in the pern stack tutorial and applying the MySQL restful API instead.

Video Time Stamps

0:00 - 2:23 Demo & Purpose
2:23 - 7:46 Setting Up MySQL in Command Line
7:46 - 21:08 Start Building Server, Database, and Table
21:08 - 36:44 Build Restful API with MySQL Queries
36:44 - 42:29 Restful API Review
42:29 - 43:23 Adding to Previous Tutorial React Todo List

[muhammadnurali]

Hi, is there any way to return the data after insert or update the data into column with mysql ? Like you did in postgres tutorial using returning *

[frixa_rstm]

Thank you for the tutorial! Very good explained! I watched your course on FCC, it was also awesome)



PS: It'd be great if you made a tutorial on how to make simple full stack app with GraphQL using any of these graphql servers: apollo, yoga, express-graphql

[realche]

Hi I have a question, if i just want to get the id of a todo how can i do that. Like I dont wanna return the id and the description like that res.json(totos[0]) but i wanna have the id. I tried this res.json(totos[0].id) but it didnt work

[sokealy]

Please make this tutorial with mssql (SQL Server), thanks.

[gabrielnascimento]

I think it would be great to use adonis as well.