Shulou(Shulou.com)06/01 Report--

Let's talk about how MySQL Workbench works. The secret of the text is that it is relevant to the topic. So, no gossip, let's go straight to the following, I believe you will benefit from reading this article on how to operate MySQL Workbench.

I. layout introduction

Second, create a database

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

Third, create a data table

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 non-empty UQ:unique unique index BIN:binary binary data (larger than text) UN:unsigned unsigned (non-negative) ZF:zero fill fill 0 for example, the field content is 1 int (4), the content is displayed as 0001AI:auto increment self-increment

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

Fourth, 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.

Is there anything you don't understand about how to operate the above MySQL Workbench? Or if you want to know more about it, you can continue to follow our industry information section.

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.