How one can create tables and add information to MySQL database with MySQL Workbench

Many database directors are snug working inside the command line. To them, it is as environment friendly as a piece surroundings might be. To others, nonetheless, the command line is just too cumbersome to be environment friendly. Thankfully, for these customers, there are many GUIs accessible to make the duty simpler. One such GUI is MySQL Workbench. This explicit device is among the most interesting domestically put in MySQL consumer instruments you will discover. It is cross-platform, open supply, and extremely straightforward to make use of.

I’ll present you simply how straightforward it’s to utilize MySQL Workbench. To take action, I will stroll you thru the method of making a database, including a desk to that database, after which including information to the desk.

SEE: Server deployment/migration guidelines (Tech Professional Analysis)

What you want

I will use MySQL Working 6.three, which has drastically developed from older variations of the device. My occasion of MySQL Workbench will hook up with a MySQL database, housed on Ubuntu Server 18.04. You’ll want to be sure you have MySQL arrange for distant connections (See: How one can arrange MySQL for distant entry on Ubuntu Server 16.04 (This additionally works for Ubuntu 18.04).

I’ll assume you have already got MySQL Workbench put in.

Making a database

The very first thing to do is create a database (aka Schema). Open MySQL Workbench and hook up with your database server. From the database residence display screen (Determine A), right-click a clean spot beneath the SCHEMAS pane and choose Create Schema.

Determine A

Figure A

The MySQL Workbench principal window.

Within the ensuing window (Determine B), give the schema (database) a reputation and (if needed) choose a Default Collation.

Determine B

Figure BFigure B

When you title your schema, click on the Apply button and, when prompted, evaluation the SQL Script and click on Apply once more. As soon as the schema is created, shut the SQL Script window. You are able to create a desk.

Making a desk

I’ve created a database known as SERVERS, that will likely be listed within the SCHEMAS pane. Increase that itemizing, right-click the Tables entry, and choose Create Desk. Within the new window (Determine C), title the desk.

Determine C


Double-click beneath Column Identify, and it’s best to be capable to sort the title of the primary column. When you do this, you possibly can then choose the Datatype for the column (Determine D).

Determine D

Figure DFigure D

Making a column for the desk.

Proceed including columns till your desk is full. Click on Apply to execute the SQL Script. Your desk is now prepared for information.

Including information to a desk

It is now time to populate that desk with some information. That is the place it will get difficult. In earlier incarnations of MySQL Workbench, a button might be discovered on the house display screen that took you on to the desk information entry part. That’s no extra. To be able to begin including information to a desk, right-click the desk (within the SCHEMAS pane) to be modified and click on Choose Rows. You’ll then end up in a window that means that you can enter information (Determine E).

Determine E

Figure EFigure E

On this window, you possibly can both use the end result grid or open the shape editor. For the quickest path to success, use the end result grid (which is the default). Double-click the primary entry in one in every of your columns and kind the information to be added. After getting into the required information, hit Enter in your keyboard. Double-click beneath that newly created row and create one other. When you add your whole information, click on Apply to execute the SQL Script.

The shape editor is simply as straightforward to make use of; you solely want to recollect to click on the Subsequent Entry button (single right-pointing arrow) to maneuver to the following information row (Determine F), earlier than getting into new information.

Determine F

Figure FFigure F

Your database is prepared

Congratulations, you efficiently created a database, added a desk, and entered information into the desk. Your database is able to use.

Open Supply Weekly E-newsletter

You do not wish to miss our ideas, tutorials, and commentary on the Linux OS and open supply functions.
Delivered Tuesdays

Enroll in the present day

Additionally see


Picture: Jack Wallen

Supply hyperlink

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *