ANTICHAT — форум по информационной безопасности, OSINT и технологиям

CREATE TABLE `some_table` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`some_field1` VARCHAR( 255 ) NOT NULL ,
`some_field2` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` )
)

1,Test content 1.1,Test content 1.2
2,Test content 2.1,Test content 2.2
3,Test content 3.1,Test content 3.2
4,Test content 4.1,Test content 4.2
5,Test content 5.1,Test content 5.2
6,Test content 6.1,Test content 6.2
7,Test content 7.1,Test content 7.2
8,Test content 8.1,Test content 8.2

LOAD DATA INFILE 'С:\\Temp\\some_file.txt' INTO TABLE some_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'