How to perform bulk insertion in Mysql with auto increments of a primary key Guid?

Question

I need to insert some records into my Mysql table. I have a text document with values. I have 7 columns in my content entry. be that as it may, in my table I have 8 columns. that is, I have a primary key section of Guid. I made this table at the moment. How can I insert these values ​​into the mysql table since I don't have a pointer? Any help would be really appreciated.

Here is my text file: I want to insert a zip code, city, etc. With a comma ..

00501, + 40.922326, -072.637078, Holtsville, New York, Suffolk, UNIQUE 00544, + 40.922326, -072.637078, Holtsville, New York, Suffolk, UNIQUE

etc..

I tried this request. but does not work.

LOAD DATA INFILE 'F:/../ZIP_CODES.txt'
INTO TABLE dbo.mastertable
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n';

, 1 . , .

Answer 1

LOAD DATA LOCAL INFILE 'F:/../ZIP_CODES.txt' 
        INTO TABLE dbo.mastertable FIELDS TERMINATED BY ','  
        LINES TERMINATED BY '\n' IGNORE 1 LINES;