SQL/PHP创建DB和加载.csv - SQL/PHP Create DB and load .CSV

SQL/PHP Create DB and load .CSV

本文关键字：加载 csv DB 创建 PHP SQL | 更新日期: 2023-09-27

到目前为止，我已经删除了所有的表，并创建了数据库，这是工作。但是当我尝试创建一个新表并加载一个。csv文件时，它不会工作。

mysql_select_db($dbName, $dbConnection);
$sql = "CREATE TABLE ".$dbTable." (ID int(6) auto_increment NOT NULL, Username varchar(20) NOT NULL, Password varchar(20) NOT NULL, UserType int(1) NOT NULL, FirstName varchar(15) NOT NULL, LastName varchar(15) NOT NULL, DOB DATETIME NOT NULL, Phone varchar(15) NOT NULL, Department varchar(15),PRIMARY KEY(ID))";
if(mysql_query($sql, $dbConnection))
{
    echo("Table '".$dbTable."' created<br />");
}
else
{
    echo("Error creating table '".$dbTable."': ".mysql_error()."<br />");
}
$sql = "LOAD DATA INFILE 'users.csv' INTO ".$dbTable." FIELDS TERMINATED BY ',' (ID, Username, Password, UserType, FirstName, LastName, DOB, Phone, Department)";
if(mysql_query($sql, $dbConnection))
{
    echo("Added records to '".$dbTable."' table<br />");
}
else
{
    echo("Error inserting records into '".$dbTable."': ".mysql_error()."<br />");
}

你可以试试这个。我希望它能起作用

    LOAD DATA INFILE '<filePath>' 
    INTO TABLE <tableName> 
    FIELDS TERMINATED BY ',' 
    ENCLOSED BY '"'
    LINES TERMINATED BY ''n'
    IGNORE 1 ROWS
    (ID, Username, Password, UserType, FirstName, LastName, DOB, Phone, Department);

更具体的错误，尝试输出

 mysql_error();

中的错误处理，并确保.csv文件路径是正确的。或者进入mysql错误日志，并发布:

 tailf /mysql.log or tail -f /mysql.log