So right here it's a single command on a single line and it's going to say ’CREATE SCHEMA devcamp_sql_course_schema’. If that's not something that you want to do then this is a great option. Without this, we'd have to write all of this from scratch in the terminal. It will then show you exactly what's been created.
#Mysql workbench download schema code#
if you're not that familiar SQL, MySQL workbench will actually create a decent amount the SQL code for you. This is one of the really nice features of using a tool like MySQL workbench. Now if I click on “apply” this is going to pop up a box that says “Review the SQL script to be applied to the database”. You don't have to make any other changes besides giving the schema a name. I am going to name this is the devcamp_sql_course_schema. So if you come up here to the top left-hand corner of MySQL workbench, you can see that if I hover over the button it says “create a new schema in the connected server.”Ĭlick on the button and it will pop open this dialog box in a new tab. We're going to go through what we need to do in order to create one from scratch. There's some sample data here this is from a few test databases that I have on my system. You can see the schema’s on the left-hand side. It's a way where we can define where our tables exist and how they relate to one another. We are able to store data that relates to other tables in our schema. A database is going to be made up of all kinds of tables that are in different places. A schema is a workspace for our database that allows us to group all of our data together.
We're going to walk through how we can create a database schema. On the left-hand side, we already walked through the server status. I'm going to use the new connection that I created in the last guide. So if you open up MySQL workbench and double click on the SQL connection that you made. We can start creating what we need to do in order to go through the course. Now that we have MySQL installed and we've configured MySQL workbench.
0 kommentar(er)
