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

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number LINES]
    [(col_name,...)]
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number LINES]
    [(col_name,...)]

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'