Consult, mysql how to identify a CSV file field,
Example: I want to import a CSV file, for example, the normal process is I create a table first, and then define the fields, to import again,
But because of the CSV file is too large, I don't want to open this CSV, so is there any way in the mysql on the premise of not open the CSV file that CSV form inside the names of the fields, and then I put the fields according to varchar (255) is defined, then the import, so I can save this link to open the CSV,

CodePudding user response:

Help ah, thank you very much! Because of frequent use, open the CSV is too large, each time is too slow, there are millions of line, inside a CSV,, although with UE will open, but every time is also very troublesome,

CodePudding user response:

Both Windows and Linux, you can use more filename to paging view the file, see the field information, one page is enough, often see information is more filename, press Ctrl + C to terminate don't show the back of the can

CodePudding user response:

Mysql support CSV engine

CodePudding user response:

Mysql support CSV!