By import of a text file with 'load data infile'. The actual field is enclosed by "" an contains two names separated with ',' or a space. Fields in textfile is also separated with ",". Import puts the later part in the next field. Only the first field in lines is affected, one of ten lines is not.
Please help!
Olov
User Profile
Collapse
-
Olov started a topic MySQL Load data infile divides data field in two parts. The later moved to next fieldin MySQLMySQL Load data infile divides data field in two parts. The later moved to next field
No activity results to display
Show More