To import the TXT file into the database (using Navicat), the column corresponding to the problem, there is a diagram

：

I have Coursera data with Python crawlers exist in the TXT file, I intend to import these files into the MySQL database table (using NAVICAT), each TXT store a field data, but when I actually import, there is no way to let left and right one by one corresponding, Instead, the data content in my field cannot be used, such as: the course account cannot be matched with the corresponding URL link. Ask the great God to answer! Thx!

Reply content:

：

I have Coursera data with Python crawlers exist in the TXT file, I intend to import these files into the MySQL database table (using NAVICAT), each TXT store a field data, but when I actually import, there is no way to let left and right one by one corresponding, Instead, the data content in my field cannot be used, such as: the course account cannot be matched with the corresponding URL link. Ask the great God to answer! Thx!

I have put Coursera data in a TXT file with a Python crawler, and intend to import these files into the MySQL database table (using NAVICAT), each TXT store a field of data,

It's your own problem, who makes you txt with only one field of data, importing another TXT will write another field in the new line, which is common sense. You use Navicat to export a txt to see the normal format.

It is recommended that you write a script merge 2 fields from 2 txt files into two fields in a CSV file, and then manually import the MySQL through Navicat

Or

Write a script directly to read two txt directly into MySQL

