Shulou(Shulou.com)05/31 Report--

This article mainly introduces the use of workbench in mysql, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Workbench is an ER and database modeling tool designed specifically for MySQL. It provides visual design, modeling, and database management capabilities to help create new physical data models and modify existing MySQL databases through reverse or forward engineering and change management functions.

Operating environment of this tutorial: windows7 system, MySQL Workbench7.3.9 version, DELL G3 computer

Workbench is an ER and database modeling tool designed for MySQL, an integrated desktop software, and a next-generation visual database design and management tool. It has both open source and commercial versions. The software supports Windows and Linux systems and can be downloaded from https://dev.mysql.com/downloads/workbench/.

MySQL Workbench is a visual database design software that helps to create new physical data models and modify existing MySQL databases through reverse or forward engineering and change management functions. It also supports all the objects that make up the database, such as tables, views, stored procedures, triggers, etc.

MySQL Workbench provides visual design, modeling, and database management functions for database administrators, program developers, and system planners. It includes ER models for creating complex data modeling, forward and reverse database engineering, and can also be used to perform document tasks that are often time-consuming and difficult to change and manage. The MySQL workbench can be used on Windows,Linux and Mac.

Layout introduction

Create a database

Step 1: click on the red place in the following picture

Step 2: name the database and follow Apply,Apply and finish in order

Create a datasheet

Step 1: select the database and double-click

After double-click

Step 2: right-select tables and select create tables

Step 3: populate the table field information

PK:primary key primary key

NN:not null is not empty

UQ:unique unique index

BIN:binary binary data (larger than text)

UN:unsigned unsigned (non-negative)

ZF:zero fill padding 0 for example, if the field content is 1 int (4), the content is displayed as 0001

AI:auto increment self-increasing

You can double-click the information for the input field in the list above, or you can enter the information directly in the input box below.

Step 5: after entering the field information, press Apply directly to end

Import data

Step 1: right-click the table and select Select Rows-Limit 1000

Step 2: writing a small amount of data

A small amount of data is filled in directly in the list.

Step 3: a large number of data import methods

There are two ways to import excel tables in workbench:

Method 1:

Click the button indicated by the arrow and select the .csv file (save excel as a subtype file) to complete the import. However, this method has a drawback: it imports according to the order of the fields in the table, and all excel fields need to be in the same order as the fields in the table. If not, you can insert an empty column in the excel.

Method 2:

It is more complex, but manual correspondence can be achieved:

1. Right-click the form for which you want to import data, as shown in the figure: [never select the first one]

2. Select the import file you want to prepare, and then next all the time

Note: click the button marked in the red circle, pop up the option (Opinions), and select CR LF (windows system "/ rzone") between rows; the encoding format utf-8; list section selects the corresponding fields as needed; then click next until the execution is complete to complete the data import.

Thank you for reading this article carefully. I hope the article "what is the use of workbench in mysql" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.