If your schema name is too long you can grab the bar next to it and drag it out. We can now see the "devcamp_sql_course_schema" schema. So now when I click close, you can see the schema here on the left-hand side. In this case, we want it to create a database schema for us. MySQL workbench is simply giving commands to the system so that it can understand what we're wanting to do. So that's I want you to kind of keep in mind that all of these things whether you see someone do it in the command line or you see it in MySQL workbench, they're pretty much all the same.
Press “apply” and it says “SQL statement was successfully applied to the database.”ĭoing it this way would be the exact same as if we went in the terminal, opened up a connection to MySQL, and ran then that schema creator. So what this is going to do is give us our names pacing and our grouping that can store all of our tables inside. 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 CREATE DATABASE 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)
