使用php将csv文件加载到sql数据库

wnavrhmk  于 2021-06-25  发布在  Mysql
关注(0)|答案(0)|浏览(174)

我需要将学生的csv文件加载到数据库中名为student的表中。当我运行此代码时:

<?php require ('../connect_db.php');?>
<?php
$query = <<<eof
    LOAD DATA INFILE 'E:\xampp\htdocs\student.csv'
    INTO TABLE student
    [FIELDS 
        [TERMINATED BY ',']
        [ENCLOSED BY '""']
    ]
    LINES TERMINATED BY '\n'
    IGNORE 1 ROWS
    (Student_ID,Forename,Surname,@Date_Of_Birth,Year_Group)
    SET Date_Of_Birth = STR_TO_DATE(@Date_Of_Birth, '%d/%m/%Y');
eof;

if (mysqli_query($dbc, $query)) {
        #If the query is successfully completed the following will be displayed
        echo "New students created successfully";
    } else {
        #This outputs any error that may occur to do with the query
        echo "Error: " . $query . "<br>" . mysqli_error($dbc);
    }#This c
?>

我得到这个错误:
错误:将数据填充“e:mpp\htdocs\student.csv”加载到表student[字段[以''终止,'][以''括起来]]行,以''终止忽略1行(student_id,forename,surname,@date_of_birth,年份组)设置出生日期=str\u to \u date(@date\u of \u birth,'%d/%m/%y');sql语法有错误;检查与您的mariadb服务器版本相对应的手册,以了解在第3行“[字段[以''终止],'][以''括起来]]行附近使用的正确语法
我该怎么办?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题