From the course: Angular: Creating and Hosting a Full-Stack Site
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Set up a MySQL database
From the course: Angular: Creating and Hosting a Full-Stack Site
Set up a MySQL database
- [Instructor] So now that we're connected to our local my SQL instance, what we're going to do is set up a database that our backend will be able to connect to and store data in. The first thing we have to do here is we have to actually create a specific database that our backend will use and the way that we do that is by clicking on this little database thing with the plus sign up at the top here and we're going to create a new schema which is basically just a new database than an application can use. So we're going to call this schema buy and sell just like the name of the site that we've been working on. And we're going to leave the default character set and default collation on and click apply. And then we're going to click apply here. And we should see at the bottom here that that was successful so the next thing we're going to do is create a table to hold the listings for our application. In a larger application, our…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Why MySQL?2m 16s
-
(Locked)
Install MySQL and MySQL Workbench3m 19s
-
(Locked)
Set up a MySQL database5m 32s
-
(Locked)
Connect to a MySQL database from Node6m 44s
-
(Locked)
Rewrite the listings endpoints8m 20s
-
(Locked)
Create an endpoint for adding views5m 29s
-
(Locked)
Create an endpoint to get a user listing3m 13s
-
(Locked)
Create an endpoint to create listings6m 13s
-
(Locked)
Create an endpoint to edit listings4m 34s
-
(Locked)
Create an endpoint to delete listings2m 33s
-
-
-
-
-