From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Creating a table using the MySQL Workbench UI

Creating a table using the MySQL Workbench UI - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Creating a table using the MySQL Workbench UI

“

- [Instructor] All right, so now that our schemas are created, we can begin populating those schemas with tables that will contain records of data. Just like when we created our schemas, we can create tables using Workbench's UI tools or we can do it with SQL code. Again, this is up to you, totally a matter of preference. In this video, I'll be showing you how to do it with the UI tools, and there'll be another video where we show you how to do it with SQL code. So, let's jump into Workbench and walk through it. All right, so the first thing that we'll need to do before we actually create the table, we're going to specify which schema we want to create that table in, and there's a couple of ways to do that. So, one, we can type USE and then name the schema. That's the USE statement in SQL. So, let's say I want to create a table in my first schema, I'll say, USE myFirstSchema, and I spelled it wrong, so let's make sure that we have that correct, and we'll run that. So, now what's…

Contents