Navicat How to set the separator

　　 Navicat How to set the separator

TXT defines the record delimiter, the field delimiter, and the text qualifier for the file.

Select fixed width to import files in fixed-width format text, click to separate the bounds of the source line, and then drag and drop the line to move or double-click to remove it.

Xml

XML definition tags to identify table columns.

Treat the properties of a label as a table field

For example:

When checked, Navicat will identify "age" with "id" and "Name" as table fields, otherwise only "id" and "name" will be imported as table fields. It should be noted that NAVICAT does not support multiple layers of XML files.