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

This article mainly introduces the method of importing navicat into mysql, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

How does navicat import mysql?

First open Navicat for MySQL, and then right-click to select New Database with the same name as the data we want to import.

After clicking OK, we can see the data we just created on the left, and then right-click and select "run SQL File" will pop up a box and click "..." Select the path where the file is located

Click start and the file will be imported successfully!

Strictly speaking, what Navicat for MySQL exports is not the database, but the data and structure of all the tables in the database. So, if you don't create a corresponding database, but choose a random data import, the result is that the database has several more tables that have just been imported.

The above is all the contents of this article "the method of importing navicat into mysql". Thank you for reading! Hope to share the content to help you, more related knowledge, 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.