Mysql shell install#

Just for some info, below are the other table schemas. I know we are missing some tables but they are not so different from the ones we created above. Then, in the foreign key table, set the name of the foreign key, the reference table, and the column which will serve as a foreign key in book table that is category_id.Īnd now our database is ready. Just click on the bookstoredb > tables > create tablesįor creating category_id as foreign key, just look to the bottom and select foreign keys. Taking every column into consideration we can use MySQL workbench table design to create a book table. Here we are going to use category_id as the foreign key to establishing this relationship. But, I won’t go ahead and create all these as it would get too large.įor now, let’s create a book table which has a one-to-many relationship with category. Now we are left with five more tables: book, customer, review, book_order, and order_details. Using MySQL Workbench’s Table Design Feature Same as for users, we make changes to the category table making category_id as the primary key. We are going to make some changes to the user’s table, adding user_id as the primary key and auto increment.Ĭheck the PK, AI boxes and then click apply, which then runs a SQL query to make the desired changes. To alter the table using workbench we can right-click, choose to alter table, and alter it to our wishes. Once created, tables can be altered provided that the data stored for the previous columns is dealt with. We can’t create one if we already have one with the same name, the same can be seen in the action output.

“If not exists” is written because we already have one. Steps to add a table using MySQL workbench:Ĭategory_id int( 11) not null auto_increment, Now, as we are connected to our database, we can start adding our tables to the database using MySQL CLI.Ĭommand: desc users ( to get details of users table)įor this, we first have to open the MySQL workbench which we installed with the MySQL server. S h o w d a t a b a s e s c o n n e c t b o o k s t o r e d b Use the following command to check and connect to our database: 1 Let’s first create our database BookStoreDB using MySQL command-line client. Other ways to check on MySQL server: > sc query mysql80 If your status is stopped you can right-click on MySQL services and start the service. As you can see below, mine is MySQL80, and is up and running. To confirm that, go to Task Manager > Services and find your version of MySQL.

Mysql shell install#

You will need the following packages to get started:Īfter we install the above packages, we must make sure that MySQL is running in the system. Using MySQL workbench’s table design feature In this article we will be learning three ways to create the database :

Our schema for the articles is BookstoreDB consisting of seven different tables: users, category, book, customer, review, book_order, and order_detail.īelow is the database design table for our book store project.

It is developed and distributed by Oracle Corporation. In this article, I will be designing a database using MySQL CLI and our framework will be JavaEE. While designing a database we must visualize the relationships between entities well. Beginners create applications without knowledge of database design, resulting in inflexible, inefficient applications. Creating a database is the most crucial part of your application and, if done right, doesn’t need maintenance.