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

How to import text into mysql? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The method of importing the text into mysql: first, create a table, then right-select the import wizard, select the format of the text file [.txt]; then select the path and code [utf-8], and select the separator; then select the title, click next; finally, click start Import.

How to import text into mysql:

1. The first step is to open mysql on our computer and create a new database and a table. The fields designed in the table need to correspond to the number of columns of the imported text document, and which field corresponds to which column of the txt text document, as shown below:

2. After the table is established in step 2, right-click the table and select the Import Wizard, as shown in the following figure:

3. After entering the import wizard interface in the third step, select the format of the import text file .txt, and click next, as shown below:

4. In step 4, select the path of the txt text document to be imported, select utf-8 for encoding, and click next, as shown below:

5. Step 5: select the delimiter, which means to distinguish each column of the text document by comma, semicolon, space, etc. Here, you choose to distinguish by space, and click next, as shown in the following figure:

Step 6. Select which row is the title of the list and which row is the first data row. Select 1 here, and click next, as shown in the following figure:

7. By default, click next. The source table here refers to the txt text document, and the target table is the database table to import data, as shown in the following figure:

8. The fields of the database table will be displayed by default in step 8. You need to select the corresponding column from the source field, that is, the txt text document. After selecting it, click next, as shown below:

9. Select the imported mode in step 9, and select add: add records to the target table, and click next, as shown in the following figure:

10. Go to the last step of importing txt text document, click start Import, wait for the import to be completed, click close, open the database table, you can see that the txt text document data has been imported, as shown in the following figure:

Thank you for reading! After reading the above, do you have a general idea of how to import text into mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

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.