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

This article shows you how to import oracle data into mysql, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Search all the data in the eventlogs table with select * in PL/SQL, and then right-click "Copy to Excel", as shown below:

2. Save the data as an excel table and rename it, as shown below:

3. Open the visualization tool of mysql. Here is Navicat, select the table, and click the Import Wizard, as shown below:

4. Select the "execel file" of "Import Type" in the above figure, and then click "next", as shown in the following figure:

5. Next, you will be asked to select a file, select the excel file you have saved, and select "SQL Result", as shown in the following figure:

6. Then click the next step until step 6 to fill in the target field. The first field is usually empty. Fill in it according to your needs. I fill in "_ id" here and set it as the primary key. As shown in the following figure:

7. Then click next all the time, and click start at the last step. A "sql result" table will appear and rename it to the table you want. As shown in the figure:

The above is how to import oracle data into mysql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, 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.