Home >Database >Mysql Tutorial >How to use MySQL Workbench
This article introduces the use of MySQL Workbench for everyone to learn and compare operations.
Recommended courses: MySQL Tutorial.
1. Layout introduction
2. Create database
Step 1: Click on the red area in the picture below
3. Create a data table
Step 1: Select the database and double-click
##After double-clicking
##Step 2: Right-click tables and select create tables;
Step 3: Fill in the table field information
PK: primary key
#Step 5: After entering the field information, press Apply directly to end
4. Import data
Step 1: Right-click on the table and select Select Rows -Limit 1000
Step 2: Small amount Writing of data
For a small amount of data, fill in the data directly in the list
# #Step 3: A large number of data import methods
There are two ways to import the excel table in the workbench:Method 1:
Click where the arrow points button, select the .csv file (save excel as a sub-type file), confirm to complete the import; however, this method has a flaw, it is imported in the order of the fields in the table, and all excel fields need to be consistent with those in the table. The order of the fields is exactly the same, if not, just insert an empty column in excel;
Method 2:is more complicated, but manual correspondence can be achieved :
1. Select the table to be imported and right-click, as shown in the figure: [Never select the first one]
2 , select the imported file to be prepared, and then keep next
Note: Click the button marked with a red circle to pop up the options (Opinions), and select CR LF ( Windows system "/r/n"); Encoding format utf-8; Select the corresponding fields in the list part as needed; then click Next until the execution is completed, then the data import can be completed;
The above is the detailed content of How to use MySQL Workbench. For more information, please follow other related articles on the PHP Chinese website!