From the course: MySQL Database Administration

Unlock this course with a free trial

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

Creating a schema using the MySQL Workbench UI

Creating a schema using the MySQL Workbench UI - MySQL Tutorial

From the course: MySQL Database Administration

Creating a schema using the MySQL Workbench UI

- [Instructor] All right, we're ready to learn how to create a new Schema using Workbench's user interface tools. Like we said before, the terms Schema and database will be used interchangeably in MySQL and in this course so that we can discuss a collection of data tables which relate to one another. So anytime you hear Schema or database, we're talking about the same thing. We can create a new Schema using Workbench's user interface tools, and this only takes a few clicks, it's really easy. This next point is important. Whether we create the Schemas using the UI tools or with SQL code, it's all a matter of preference. They're going to create the same Schemas, so you should learn both ways and then decide which way you prefer, but it doesn't make a difference in terms of the Schema that gets created, whether or not you're using these UI tools or you do it with SQL code. So let's jump into Workbench and I'll walk you through an example right now. So if you've gotten through the install…

Contents