{"id":57985,"date":"2018-06-25T15:00:23","date_gmt":"2018-06-25T12:00:23","guid":{"rendered":"http:\/\/examples.javacodegeeks.com\/?p=57985"},"modified":"2022-07-08T15:44:25","modified_gmt":"2022-07-08T12:44:25","slug":"mysql-workbench-tutorial","status":"publish","type":"post","link":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/","title":{"rendered":"MySQL Workbench Tutorial"},"content":{"rendered":"<p><a href=\"https:\/\/www.mysql.com\/products\/workbench\/\" target=\"_blank\" rel=\"noopener\">MySQL Workbench<\/a> is one of the most used tools to work with MySQL-based databases and manage schema for a database, data in tables, and reverse engineering the&nbsp;schema definitions. The reason&nbsp;MySQL Workbench is so popular is the easiness it provides when working with MySQL databases. It provides a visually intuitive DB design tool that integrates many functionalities like:<\/p>\n<ul class=\"wp-block-list\">\n<li>Creating databases<\/li>\n<li>Managing databases and related properties like user-access permissions<\/li>\n<li>Database design using a visual DB designer which allows us to create class-diagrams<\/li>\n<li>DB administration &amp;&nbsp;maintenance<\/li>\n<\/ul>\n<p>Most of the <strong>Database administrators prefer using&nbsp;MySQL Workbench<\/strong> over many other similar tools available in the marketplace.<\/p>\n<p>You can also check this tutorial in the following video:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><a href=\"https:\/\/www.youtube.com\/watch?v=vjOh7eQjBJw\"><img decoding=\"async\" src=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/07\/MySQL-Workbench-Tutorial-1024x576.jpg\" alt=\"\" class=\"wp-image-113855\" width=\"512\" height=\"288\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/07\/MySQL-Workbench-Tutorial-1024x576.jpg 1024w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/07\/MySQL-Workbench-Tutorial-300x169.jpg 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/07\/MySQL-Workbench-Tutorial-768x432.jpg 768w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/07\/MySQL-Workbench-Tutorial.jpg 1280w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/a><figcaption>MySQL Workbench Tutorial &#8211; video<\/figcaption><\/figure>\n<\/div>\n<div class=\"toc\">\n<h3>Table Of Contents<\/h3>\n<dl>\n<dt><a href=\"#introduction\">1. Introduction to MySQL Workbench<\/a><\/dt>\n<dt><a href=\"#install_workbench\">2. Installing MySQL Workbench<\/a><\/dt>\n<dd>\n<dl>\n<dt><a href=\"#install_macos\">2.1 Installing on Macintosh OS<\/a><\/dt>\n<dt><a href=\"#install_windows\">2.2 Installing on Windows OS<\/a><\/dt>\n<dt><a href=\"#install_linux\">2.3 Installing on Linux variants<\/a><\/dt>\n<\/dl>\n<\/dd>\n<dt><a href=\"#started_workbench\">3. Getting Started with MySQL Workbench<\/a><\/dt>\n<dd>\n<dl>\n<dt><a href=\"#make_sql_connection\">3.1 Making a new MySQL connection<\/a><\/dt>\n<dt><a href=\"#manage_db\">3.2 Managing the Database<\/a><\/dt>\n<\/dl>\n<\/dd>\n<dt><a href=\"#manage_table\">4. Managing Database and Table schema<\/a><\/dt>\n<dd>\n<dl>\n<dt><a href=\"#use_gui\">4.1 Using the GUI for managing schema<\/a><\/dt>\n<dt><a href=\"#make_table\">4.2 Making new Tables in a Database<\/a><\/dt>\n<dt><a href=\"#insert_data_sql\">4.3 Inserting Data with SQL scripts<\/a><\/dt>\n<\/dl>\n<\/dd>\n<dt><a href=\"#create_model\">5. Creating a model in MySQL Workbench<\/a><\/dt>\n<dd>\n<dl>\n<dt><a href=\"#create_schema_model\">5.1 Creating a Schema using Workbench model interface<\/a><\/dt>\n<\/dl>\n<\/dd>\n<dt><a href=\"#reverse_engineering\">6. Reverse Engineering<\/a><\/dt>\n<dt><a href=\"#conclusion\">7. Summary<\/a><\/dt>\n<\/dl>\n<\/div>\n<h2 class=\"wp-block-heading\" id=\"introduction\">1. Introduction to MySQL Workbench<\/h2>\n<p>Based on the official website, MySQL Workbench is defined as:<\/p>\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.<\/p>\n<\/blockquote>\n<p>Due to its availability on all the populator OS platforms, it can be used freely over your preferred Operating System to do a lot of tasks actually and can single-handedly perform operations for which you don&#8217;t need to install any more tools for DB administration. One of the most complex tools&nbsp;MySQL Workbench provides is a DB migration tool that can be used to migrate&nbsp;Microsoft SQL Server, Microsoft Access, Sybase ASE, PostgreSQL, and other RDBMS tables, objects, and data to MySQL database.<\/p>\n<h2 class=\"wp-block-heading\" id=\"install_workbench\">2. Installing MySQL Workbench<\/h2>\n<p>Before continuing to understand the features presented by&nbsp;MySQL Workbench and basic tools, we need to install the Workbench on our machine. If you want to run a local database, you&nbsp;<strong>must install a compatible MySQL server<\/strong>&nbsp;on the machine as well. If you haven&#8217;t installed that yet, follow&nbsp;<a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/wb-installing-windows.html\" target=\"_blank\" rel=\"noopener\">this<\/a> link to get the server up and running so that we can continue installing the Workbench too.<\/p>\n<p>Once the&nbsp;MySQL server is up and running on your local machine, we&#8217;re ready to move forward to install the Workbench on our system. We can download the Workbench installer file from <a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\" target=\"_blank\" rel=\"noopener\">here<\/a> for specific Operating Systems.&nbsp;As shown in the image below, MySQL Workbench is available for Windows, MacOSX &amp; multiple variants of Linux systems:<\/p>\n<p>The installation process is pretty straightforward. The below subsections cover the installation process for specific Operating Systems.<\/p>\n<h3 class=\"wp-block-heading\" id=\"install_macos\">2.1 Installing on Macintosh OS<\/h3>\n<p>To install&nbsp;MySQL Workbench on a&nbsp;Macintosh OS, download the&nbsp;<strong>.dmg<\/strong> package file and open it which will bring up the following installer window:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-download.png\"><img decoding=\"async\" width=\"820\" height=\"377\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-download.png\" alt=\"MySQL Workbench - Downloading for different OS\" class=\"wp-image-57987\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-download.png 820w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-download-300x138.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-download-768x353.png 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><figcaption>Downloading MySQL Workbench for different OS<\/figcaption><\/figure>\n<\/div>\n<p>Follow the steps as presented by the application window once we open the installer file, like moving the file to the applications folder as mentioned in the image:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-installing.png\"><img decoding=\"async\" width=\"526\" height=\"447\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-installing.png\" alt=\"MySQL Workbench - Copy file to Applications folder on MacOS\" class=\"wp-image-57988\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-installing.png 526w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-installing-300x255.png 300w\" sizes=\"(max-width: 526px) 100vw, 526px\" \/><\/a><figcaption>Copy file to Applications folder on MacOS<\/figcaption><\/figure>\n<\/div>\n<h3 class=\"wp-block-heading\" id=\"install_windows\">2.2 Installing on Windows OS<\/h3>\n<p>For the purpose of installation on&nbsp;Windows OS, we can download the&nbsp;<strong>.exe<\/strong> format file and set up the Workbench as the windows installer instructs. The installer will also check for all the dependencies for MySQL Workbench like MySQL server, so that should be up and running when we start installing the Workbench on the same machine. When all checks are passed, the installation will continue.<\/p>\n<p>Find more information about installing the tool on Windows OS <a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/wb-installing-windows.html\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<h3 class=\"wp-block-heading\" id=\"install_linux\">2.3 Installing on Linux variants<\/h3>\n<p>For the purpose of installation on Linux OS, we can download the&nbsp;<strong>.deb<\/strong> format file and set up the Workbench as the Linux installer instructs. On Linux, it is also possible to install the&nbsp;Workbench using the command line. Here are set of commands we can use to download and install the&nbsp;Workbench on a Linux machine:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>Downloading Installer for Linux<\/em><\/span><\/p>\n<pre class=\"wp-block-preformatted brush:bash\">sudo dpkg -i mysql-apt-config_0.5.3-1_all.deb\nsudo apt-get update\nsudo apt-get install mysql-workbench-community\n<\/pre>\n<p>This is pretty much the most straightforward set up technique in all of the platforms. We&#8217;re ready to start the&nbsp;Workbench on our OS. As we&#8217;re using a Mac, the UI window will be related to that but other platforms,&nbsp;Workbench behave in the same manner.<\/p>\n<h2 class=\"wp-block-heading\" id=\"started_workbench\">3.&nbsp;Getting Started with MySQL Workbench<\/h2>\n<p>Once we have installed and started the&nbsp;MySQL Workbench, we will see a welcome screen similar to the following depending on the OS we are using:<div style=\"display:inline-block; margin: 15px 0;\"> <div id=\"adngin-JavaCodeGeeks_incontent_video-0\" style=\"display:inline-block;\"><\/div> <\/div><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-welcome.png\"><img decoding=\"async\" width=\"820\" height=\"569\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-welcome.png\" alt=\"MySQL Workbench - Welcome Screen\" class=\"wp-image-57990\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-welcome.png 820w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-welcome-300x208.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-welcome-768x533.png 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><figcaption>MySQL Workbench Welcome Screen<\/figcaption><\/figure>\n<\/div>\n<p>By default, the application doesn&#8217;t make any connections for the MySQL server running on localhost. We can start making new connections directly from this screen.&nbsp;The local host server can be connected only if the local MySQL server has been installed.<\/p>\n<h3 class=\"wp-block-heading\" id=\"make_sql_connection\">3.1 Making a new MySQL connection<\/h3>\n<p>To add new connections to the Workbench so that you don&#8217;t have to enter DB credentials, again and again, we can make use of the&nbsp;+ symbol shown beside the MySQL Connections Label which will present a small window, as follows:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-new-connection.png\"><img decoding=\"async\" width=\"800\" height=\"500\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-new-connection.png\" alt=\"MySQL Workbench - New Database Connection\" class=\"wp-image-57992\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-new-connection.png 800w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-new-connection-300x188.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-new-connection-768x480.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><figcaption>New Database Connection in MySQL Workbench<\/figcaption><\/figure>\n<\/div>\n<p>In this window, we can enter the DB details like the DB name, connection method, host for the DB server, port where MySQL server is running (by default, it is 3306), username and password for the database we&#8217;re connecting to.<\/p>\n<p>The connection name is an alias through which we can easily identify a DB connection where there more connections in our tab to different databases. If you&#8217;re connecting to a local MySQL server, we can specify the host as&nbsp;<strong>localhost<\/strong> with Port number 3306. Otherwise, provide the hostname and port number of the remote server. When we provide all correct details in this form, MySQL Workbench will try to connect to the server we mentioned in the details and show a connected message if it was successful in doing so:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-connection-success.png\"><img decoding=\"async\" width=\"420\" height=\"238\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-connection-success.png\" alt=\"MySQL Workbench - Connection Test\" class=\"wp-image-57993\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-connection-success.png 420w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-connection-success-300x170.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/a><figcaption>Connection Test<\/figcaption><\/figure>\n<\/div>\n<p>Once a connection is successful and you save the connection, we can access the database anytime without having to re-enter the credentials and other information in a repetitive manner.<\/p>\n<h3 class=\"wp-block-heading\" id=\"manage_db\">3.2 Managing the Database<\/h3>\n<p>Once we have made the connection to the database, we can see the following screen with various components which allows us to manage databases, analyse the query performance, modify the schema of a table and do other common operations with just a few clicks. We can see four views in the screen:<\/p>\n<ol class=\"wp-block-list\">\n<li>Management<\/li>\n<li>Instance<\/li>\n<li>Performance<\/li>\n<li>Schema<\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-home-screen.png\"><img decoding=\"async\" width=\"820\" height=\"585\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-home-screen.png\" alt=\"MySQL Workbench - Database Welcome Screen\" class=\"wp-image-57994\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-home-screen.png 820w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-home-screen-300x214.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/mysql-workbench-home-screen-768x548.png 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><figcaption>Workbench Database Welcome Screen<\/figcaption><\/figure>\n<\/div>\n<p>Let us understand each section of the panel briefly here:<\/p>\n<ul class=\"wp-block-list\">\n<li>The&nbsp;<strong>Management<\/strong> section enables us to manage and monitor the health of the MySQL server. As the number of clients connecting to the server, we can monitor how does it affect the health of the server and if we should consider modifying memory requirements for the server to increase its performance. This section also allows us to&nbsp;<strong>import<\/strong> and&nbsp;<strong>export data<\/strong> into the database.<\/li>\n<li>Next section is the&nbsp;<strong>Instance<\/strong> section. With this section, we can&nbsp;start or stop the server directly from the MySQL Workbench. Please note that <strong>this requires the MySQL server to be installed at the default location<\/strong> as MySQL Workbench will try to find the configuration file as well as server related scripts at the default location on the machine.<\/li>\n<li>The&nbsp;<strong>Performance<\/strong> section allows us to provide informative performance analysis and reports about the server health. This feature is only available in&nbsp;MySQL Server version 5.6.6 or above. So&nbsp;make sure to use that version if you want to make use of this feature.<\/li>\n<li>The last section in the panel is the&nbsp;<strong>Schema<\/strong> which is currently present in the database we&#8217;re connected to right now. If we right-click on any of the schemas, we can do many operations like creating new tables inside a schema, deleting all data and much more.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\" id=\"manage_table\">4. Managing Database and Table schema<\/h2>\n<p>If you want a way with which creating databases and tables is super-fast and easy, MySQL Workbench provides an excellent GUI through which you don&#8217;t have to write any SQL. We have the following options to create and manage databases and tables in the Workbench:<\/p>\n<ul class=\"wp-block-list\">\n<li>Using the GUI directly<\/li>\n<li>Executing SQL scripts in the Query builder<\/li>\n<\/ul>\n<p>Let&#8217;s demonstrate each of these methods here one by one.<\/p>\n<h3 class=\"wp-block-heading\" id=\"use_gui\">4.1 Using the GUI for managing schema<\/h3>\n<p>To create a new database, we can click on&nbsp;any of the existing schemas or on the blank schema window. In the context menu that opens up, select <strong>Create Schema<\/strong> as shown below:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema.png\"><img decoding=\"async\" width=\"420\" height=\"274\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema.png\" alt=\"MySQL Workbench - Create Schema\" class=\"wp-image-57996\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema.png 420w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema-300x196.png 300w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/a><figcaption>Create Schema<\/figcaption><\/figure>\n<\/div>\n<p>Once we select the specified option, we will see a new tab asking for a DB schema name:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema-window.png\"><img decoding=\"async\" width=\"748\" height=\"474\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema-window.png\" alt=\"MySQL Workbench - DB Schema Name\" class=\"wp-image-57997\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema-window.png 748w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-schema-window-300x190.png 300w\" sizes=\"(max-width: 748px) 100vw, 748px\" \/><\/a><figcaption>DB Schema Name<\/figcaption><\/figure>\n<\/div>\n<p>Select <strong>Apply<\/strong> once you have entered the values. This will open up a review screen display the SQL as shown under with the following SQL which will be executed once we select&nbsp;<strong>Apply<\/strong>:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>SQL Query for creating DB<\/em><\/span><\/p>\n<pre class=\"wp-block-preformatted brush:bash\">CREATE SCHEMA `jcg_schema`;\n<\/pre>\n<p>We can see the new schema in the Schemas section in the panel. When we expand the schema, we can create new Tables for the Database.<\/p>\n<h3 class=\"wp-block-heading\" id=\"make_table\">4.2 Making new Tables in a Database<\/h3>\n<p>To create a new table inside a schema, right-click on the Tables group as shown and select&nbsp;<strong>Create Table<\/strong>:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table.png\"><img decoding=\"async\" width=\"714\" height=\"218\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table.png\" alt=\"MySQL Workbench - Create Table\" class=\"wp-image-57998\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table.png 714w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-300x92.png 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/a><figcaption>Create Table in Workbench<\/figcaption><\/figure>\n<\/div>\n<p>Once you hit the option, we will be taken on a new screen that asks for more information about the structure of the table to create, what type of columns to include, and what type of data they can store. Fill in all the information with desired columns and we can move ahead with inserting some sample data into the schema with manual SQL scripts.<\/p>\n<p>When the new tab opens to create a table, we can see the following options to decide the structure of the table:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-schema.png\"><img decoding=\"async\" width=\"795\" height=\"414\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-schema.png\" alt=\"MySQL Workbench - Create table\" class=\"wp-image-58000\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-schema.png 795w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-schema-300x156.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-create-table-schema-768x400.png 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/a><figcaption>Create table&nbsp;schema in Workbench<\/figcaption><\/figure>\n<\/div>\n<p>The first and second columns above are self-explanatory. The rest of the columns are described below.<\/p>\n<p><strong>PK:&nbsp;<\/strong>Primary Key<\/p>\n<p><strong>NN:&nbsp;<\/strong>Not null<\/p>\n<p><strong>UQ:&nbsp;<\/strong>Unique data<\/p>\n<p><strong>BIN:&nbsp;<\/strong>Contains binary data<\/p>\n<p><strong>UN:&nbsp;<\/strong>Contains unsigned data<\/p>\n<p><strong>ZF:&nbsp;<\/strong>Stands for Zero-filled columns<\/p>\n<p><strong>AI:&nbsp;<\/strong>Auto-Increment the field value<\/p>\n<p><strong>G:&nbsp;<\/strong>Generated column. The value is generated using a formula for the column<\/p>\n<p>Select the checkboxes to apply specific properties to the columns you defined in the schema.&nbsp;You could make any changes if required in the script and click Apply.<\/p>\n<p>Finally, it is also possible to do so much more in the tab shown before you create the table.&nbsp;<strong>Indexes<\/strong> tab can be used to create an index on a given column in addition to the primary key of the table which will make the search on that column a lot faster but also make this table occupy more space when any data is inserted into the table. We can see these options by clicking the Indexes tab. The available options are self-explanatory as long as the user has sufficient knowledge about MySQL Database. As of now, this table does not need any more indexes to be created. Hence, we would skip to the next tab.<\/p>\n<h3 class=\"wp-block-heading\" id=\"insert_data_sql\">4.3 Inserting Data with SQL scripts<\/h3>\n<p>We can manage the schema with SQL scripts as well. The SQL scripts will be executed for the database which is currently open. Open up a query builder (which is open by default) and we can execute some SQL queries into the&nbsp;query builder to insert some data into the schema and table we just made in previous steps.<\/p>\n<p>These scripts will be normal SQL scripts with <strong>INSERT<\/strong> commands with sample values. A simple example for an SQL statement will be like:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>SQL Command for Inserting Data<\/em><\/span><\/p>\n<pre class=\"wp-block-preformatted brush:bash\">INSERT INTO `jcg_schema`.`user` (`name`, `created_at`) VALUES ('Shubham', now());\n<\/pre>\n<p>Now, we can run another SQL script to see the data in the table:<\/p>\n<p><span style=\"text-decoration: underline;\"><em>SELECT Command<\/em><\/span><\/p>\n<pre class=\"wp-block-preformatted brush:bash\">SELECT * FROM jcg_schema.user;\n<\/pre>\n<h2 class=\"wp-block-heading\" id=\"create_model\">5. Creating a model in MySQL Workbench<\/h2>\n<p>Now that we have an idea of how to create a database in the MySQL Workbench, we can start to use the MySQL workbench feature to a greater extent. The main reason for MySQL workbench being a popular tool among the DB developers and Admins is that it provides a large number of features to make DB creation easy with multiple tools like EER design tool, Model design tool, GUI for schema, table, trigger, and procedures management, utilities for performance monitoring, utilities for server management and facilities for data export, import as well as migration. In this section, we will discuss one of these important features \u2013 Model creation.<\/p>\n<p><strong>Model creation<\/strong> is another way to create schema and tables in a visual manner. Therefore, we will shorten the process of table creation from here. Although, we will cover the creation of the EER diagram from the same as well.<\/p>\n<h3 class=\"wp-block-heading\" id=\"create_schema_model\">5.1 Creating a Schema using Workbench model interface<\/h3>\n<p>A model is termed as a replica of a schema except for it being displayed visually as an <strong>EER diagram<\/strong>. In order to start with the creation of a new model, navigate to <strong>File-&gt;New Model<\/strong>.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation.png\"><img decoding=\"async\" width=\"512\" height=\"237\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation.png\" alt=\"MySQL Workbench - Create Model\" class=\"wp-image-58001\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation.png 512w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-300x139.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/a><figcaption>Create Model in Workbench<\/figcaption><\/figure>\n<\/div>\n<p>Once we are taken to the new model tab, you will find several icons placed on the top. The first three icons in the image shown below are related to File operations like <strong>create<\/strong> a new document, <strong>open<\/strong> an existing model and <strong>save<\/strong> a model. These icons are followed by <strong>undo<\/strong> and <strong>redo<\/strong> icons. The next group of icons is important here.<\/p>\n<p>To start with, click the second icon in the group \u2013 Create a new schema. It should create a new schema as shown above. A tab opens up below it and allows to configure the schema name. Next, proceed with the creation of tables by clicking Add Table in the image shown above. The table creation process is similar to the above section once the Add Table link is clicked:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/add-tabel-model.png\"><img decoding=\"async\" width=\"431\" height=\"274\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/add-tabel-model.png\" alt=\"MySQL Workbench - Model\" class=\"wp-image-58002\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/add-tabel-model.png 431w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/add-tabel-model-300x191.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/a><figcaption>Model in SQL Workbench<\/figcaption><\/figure>\n<\/div>\n<p>Try creating some tables in the schema after which we can create an EER Diagram for the same schema. In the image below, we have created two tables in the provided schema. Select the <strong>Add Diagram<\/strong> in the EER diagram section of the tab to create an EER diagram for the current schema. A new tab opens up with a blank EER diagram sheet. On the left-hand panel, there is a Catalog section marked with a red rectangle below.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-workbench.png\"><img decoding=\"async\" width=\"824\" height=\"351\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-workbench.png\" alt=\"MySQL Workbench - EER Diagram\" class=\"wp-image-58003\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-workbench.png 824w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-workbench-300x128.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/model-creation-workbench-768x327.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><figcaption>EER Diagram in Workbench<\/figcaption><\/figure>\n<\/div>\n<p>To create a new EER diagram, we can expand the tables node and <strong>drag and drop<\/strong> the tables onto the sheet. On dragging the previously created tables onto the sheet, it automatically draws a line referencing the foreign link between the tables. The tables we defined didn&#8217;t have any foreign keys, otherwise, it could have been seen clearly how tables are related to each other.<\/p>\n<p>It is also possible to create tables right away from the UI. The buttons marked with red rectangle allows you to easily add new tables in the sheet and opens up a create table UI in below the sheet. You could notice that as you add columns and foreign key constraints, they get added automatically in the EER diagram above. Thus, the EER diagram could be created using a drag and drop interface quite easily.<\/p>\n<h2 class=\"wp-block-heading\" id=\"reverse_engineering\">6. Reverse Engineering<\/h2>\n<p>It is one of the most common scenarios that developers start to create the schema of the table directly in the code instead of creating an EER diagram for understanding first. In such cases when the number of tables is a lot more,&nbsp;it is difficult to create an ER diagram from scratch. The Workbench has a solution for this situation as well.&nbsp;With Workbench&#8217;s Reverse Engineering feature, we can create an EER diagram from any existing schema at any point in time. To do so, click on <strong>Database &gt; Reverse Engineer<\/strong> feature:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-reverse-engineer.png\"><img decoding=\"async\" width=\"820\" height=\"247\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-reverse-engineer.png\" alt=\"MySQL Workbench - Navigating to Reverse Engineering\" class=\"wp-image-58004\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-reverse-engineer.png 820w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-reverse-engineer-300x90.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/workbench-reverse-engineer-768x231.png 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><figcaption>Navigating to Reverse Engineering<\/figcaption><\/figure>\n<\/div>\n<p>Once we select the given option, we will have to provide details about the DB to connect to:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/reverse-engineer-step-one.png\"><img decoding=\"async\" width=\"820\" height=\"585\" src=\"http:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/reverse-engineer-step-one.png\" alt=\"MySQL Workbench - Connecting to DB\" class=\"wp-image-58005\" srcset=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/reverse-engineer-step-one.png 820w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/reverse-engineer-step-one-300x214.png 300w, https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/06\/reverse-engineer-step-one-768x548.png 768w\" sizes=\"(max-width: 820px) 100vw, 820px\" \/><\/a><figcaption>Connecting to DB<\/figcaption><\/figure>\n<\/div>\n<p>Once this is done, we will have to select the database and continue normally till the end. Once all steps are complete, you will be presented the EER diagram for the database you selected in the complete process.<\/p>\n<p>The final presented window will show the tables in the EER diagram format. We can drag and arrange the tables for a large database if some table view is preferred over another and cover them in a limited area of the sheet too. If we want to save the diagram as an image to use it in a document, we can do so by navigating to <strong>File -&gt; Export<\/strong>. Select the option as per the format and save the diagram at the desired location.<\/p>\n<h2 class=\"wp-block-heading\" id=\"conclusion\">7. Summary<\/h2>\n<p>In this lesson, we discussed many important features provided by the MySQL Workbench&nbsp;and displayed how it can solve some very common problems for developers and administrators which is the main reason for its popularity. The major features like the creation of schema, tables, and EER diagram were also discussed. However, this is not all that Workbench has. There is always more to explore. To study all the operations and features one can do with the Workbench, feel free to explore the MySQL Workbench official <a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/wb-intro.html\" target=\"_blank\" rel=\"noopener\">website<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database, data in tables, and reverse engineering the&nbsp;schema definitions. The reason&nbsp;MySQL Workbench is so popular is the easiness it provides when working with MySQL databases. It provides a visually intuitive DB design tool that integrates many &hellip;<\/p>\n","protected":false},"author":154,"featured_media":1204,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[647],"class_list":["post-57985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Workbench Tutorial - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Workbench Tutorial - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Examples Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-25T12:00:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-08T12:44:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Shubham Aggarwal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sbmaggarwal\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shubham Aggarwal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\"},\"author\":{\"name\":\"Shubham Aggarwal\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/da48da5ffe2c95ab19f7b2162a3f30b2\"},\"headline\":\"MySQL Workbench Tutorial\",\"datePublished\":\"2018-06-25T12:00:23+00:00\",\"dateModified\":\"2022-07-08T12:44:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\"},\"wordCount\":2896,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"keywords\":[\"mysql\"],\"articleSection\":[\"sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\",\"name\":\"MySQL Workbench Tutorial - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"datePublished\":\"2018-06-25T12:00:23+00:00\",\"dateModified\":\"2022-07-08T12:44:25+00:00\",\"description\":\"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...\",\"breadcrumb\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"Bipartite Graph\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/examples.javacodegeeks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java Development\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Core Java\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"sql\",\"item\":\"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"MySQL Workbench Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#website\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Examples and Code Snippets\",\"publisher\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\/\/examples.javacodegeeks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/javacodegeeks\",\"https:\/\/x.com\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/da48da5ffe2c95ab19f7b2162a3f30b2\",\"name\":\"Shubham Aggarwal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/09\/Shubham-Aggarwal_avatar_1536328481-96x96.jpeg\",\"contentUrl\":\"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/09\/Shubham-Aggarwal_avatar_1536328481-96x96.jpeg\",\"caption\":\"Shubham Aggarwal\"},\"description\":\"Shubham is a Java Backend and Data Analytics Engineer with more than 3 years of experience in building quality products with Spring Boot, MongoDB, Elasticsearch, MySQL, Docker, AWS, Git, PrestoDB tools and I have a deep knowledge and passion towards analytics, Micro-service based architecture, design patterns, antipatterns and software design thinking.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/sbmaggarwal\/\",\"https:\/\/x.com\/sbmaggarwal\"],\"url\":\"https:\/\/examples.javacodegeeks.com\/author\/shubham-aggarwal\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Workbench Tutorial - Java Code Geeks","description":"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Workbench Tutorial - Java Code Geeks","og_description":"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...","og_url":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/","og_site_name":"Examples Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2018-06-25T12:00:23+00:00","article_modified_time":"2022-07-08T12:44:25+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","type":"image\/jpeg"}],"author":"Shubham Aggarwal","twitter_card":"summary_large_image","twitter_creator":"@sbmaggarwal","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Shubham Aggarwal","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#article","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/"},"author":{"name":"Shubham Aggarwal","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/da48da5ffe2c95ab19f7b2162a3f30b2"},"headline":"MySQL Workbench Tutorial","datePublished":"2018-06-25T12:00:23+00:00","dateModified":"2022-07-08T12:44:25+00:00","mainEntityOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/"},"wordCount":2896,"commentCount":0,"publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","keywords":["mysql"],"articleSection":["sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/","url":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/","name":"MySQL Workbench Tutorial - Java Code Geeks","isPartOf":{"@id":"https:\/\/examples.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","datePublished":"2018-06-25T12:00:23+00:00","dateModified":"2022-07-08T12:44:25+00:00","description":"MySQL Workbench is one of the most used tools to work with MySQL-based databases and manage schema for a database...","breadcrumb":{"@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#primaryimage","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2012\/12\/java-logo.jpg","width":150,"height":150,"caption":"Bipartite Graph"},{"@type":"BreadcrumbList","@id":"https:\/\/examples.javacodegeeks.com\/mysql-workbench-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/examples.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java Development","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/"},{"@type":"ListItem","position":3,"name":"Core Java","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/"},{"@type":"ListItem","position":4,"name":"sql","item":"https:\/\/examples.javacodegeeks.com\/category\/java-development\/core-java\/sql\/"},{"@type":"ListItem","position":5,"name":"MySQL Workbench Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/examples.javacodegeeks.com\/#website","url":"https:\/\/examples.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Examples and Code Snippets","publisher":{"@id":"https:\/\/examples.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/examples.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/examples.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/examples.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/da48da5ffe2c95ab19f7b2162a3f30b2","name":"Shubham Aggarwal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/examples.javacodegeeks.com\/#\/schema\/person\/image\/","url":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/09\/Shubham-Aggarwal_avatar_1536328481-96x96.jpeg","contentUrl":"https:\/\/examples.javacodegeeks.com\/wp-content\/uploads\/2018\/09\/Shubham-Aggarwal_avatar_1536328481-96x96.jpeg","caption":"Shubham Aggarwal"},"description":"Shubham is a Java Backend and Data Analytics Engineer with more than 3 years of experience in building quality products with Spring Boot, MongoDB, Elasticsearch, MySQL, Docker, AWS, Git, PrestoDB tools and I have a deep knowledge and passion towards analytics, Micro-service based architecture, design patterns, antipatterns and software design thinking.","sameAs":["https:\/\/www.linkedin.com\/in\/sbmaggarwal\/","https:\/\/x.com\/sbmaggarwal"],"url":"https:\/\/examples.javacodegeeks.com\/author\/shubham-aggarwal\/"}]}},"_links":{"self":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/57985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/users\/154"}],"replies":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=57985"}],"version-history":[{"count":0,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/57985\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=57985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=57985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/examples.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=57985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}