Import/Export database + Add new field in CSV format data file

Recently been busy in the laboratory, did not properly update the blog, in the process of grasping the package, encountered a lot of problems.

Because I often use Wireshark to export the capture information to a CSV file, here's a simple mark about 2 ways to import/export a CSV file to a database:

A. Simple, but slightly slower way to use Navicat for MySQLto import the database:

The process is as follows:

The installation is complete and the connection interface is configured as follows:

New Database

Go to import Wizard

Select the type of import:

Then select the file as the data source, here is the package that I have grasped before, 300w+ strip capture record

The default settings are taken directly here

Same default

I set the following to indicate that a new table

Here is the program based on the content of the speculation, note to modify the following data type, and adjust as necessary, here is a bit not very good, at present only found through the arrow keys "down" to add, no other operation, if the added data record is not filled, then automatically deleted.

I reduced the packet information to just what I needed so that the information crawled from 1G to 200+m

Half an hour, 300w+ records.

This slow, who use who know ~ ~ ~ ~

Two. Use SQL statements to import, fast!

This method has been reported error 1265 and has not yet been resolved

Import/Export database + Add new field in CSV format data file