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

The purpose of this article is to share with you the solution to the incomplete data import of navicat. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

When importing data with Navicat, although the database is imported, the amount of data is much less, the source database has more than 490000 of the data, only 55000 of the data is imported, it stops, and no error is reported.

Open the txt file with notepad, then save it (note the coding or UTF8), save it in csv format, such as: test.txt becomes test.csv, then import with navicat, import in txt format, you can successfully import the data.

Target-side database verification:

±- + | count (1) | ±- + | 497051 | ±- + 1 row in set (0.16 sec)

Thank you for reading! This is the end of this article on "the solution to the incomplete data import of navicat". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.