MySQL中的大容量插入问题

Question

我在执行以下用于批量插入的SQL命令时遇到错误。

    BULK INSERT libra.faculty
    FROM 'd\:faculty.csv'
    WITH
    (
        FIELDTERMINATOR = ',',
        ROWTERMINATOR = '\n'
    );

以下是错误消息：

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use near 'BULK
    INSERT libra.faculty
    FROM 'd:\faculty.csv'
    WITH
    (
    FIELDTERMINATOR = ',',
    RO' at line 1

Answer 1

使用LOAD DATA INFILE而不是BULK INSERT

Answer 2

将数据INFILE 'd:faculty.csv‘装入以'，’行结尾的表libra.faculty字段\n‘