Learn CRUD with React/Next.JS and MySQL (Complete tutorial)

In this video you'll learn how to do all CRUD operations with Next.JS api and MySQL database, or any database you choose to use. We'll create an API in Next.JS and then learn how to read, create, update and delete data through that API. The concept generally works with any database but in this demo you'll use a MySQL database.

CONNECT ON MY DISCORD COMMUNITY:
https://discord.gg/5zsdrxH8m8

0:00 intro
1:50 Crud Demo
4:00 Boiler Plate Setup
4:55 MySQL database setup
8:46 MYSQL user setup
11:20 MySQL DB connection
12:00 Create Next.JS API Endpoint
18:00 Default state/input forms from our app
20:53 Read Data API (GET)
25:00 Display data in our app
28:00 Create Data API (POST)
33:00 Post Data from the app
38:00 Change state with created data
40:00 Update Data API (PUT)
44:00 Update data from the app
47:00 Change state with updated data
50:19 Delete Data API (DELETE)
52:43 Delete Data from the app
55:00 Change state with deleted data
56:00 Bonus: delete data with react icons
58:40 Conclusion

SOCIALS:
Twitter: https://twitter.com/omarel
Website: https://www.omarel.com
LinkedIn: https://www.linkedin.com/in/omarelbaga
GitHub: https://github.com/oelbaga

Repo:
https://github.com/oelbaga/nextjs-mysql

Gist: Create MYSQL user to make database accessible
9:22 https://gist.github.com/oelbaga/fed237d3a2b38b2b0b2bd43286b86e12

Gist: Next.js MySQL DB Connection wrapper
12:21 https://gist.github.com/oelbaga/9e2789be304b622b9df9141544ce7b8d

Gist: Updating objects in React State
https://gist.github.com/oelbaga/b77d38eb9706b5ff01ea909e5aa24f81