将.csv文件导入sql server时出现问题

cu6pst1q  于 2021-07-24  发布在  Java
关注(0)|答案(0)|浏览(215)

该文件位于我的网站上,我想将其导入sql server,但每次运行php脚本时,它都会添加表,但不会添加信息。我试着这样做

  1. LOAD DATA INFILE '/home/u831625604/domains/andreiilinescu.com/public_html/stoc.csv'
  2. INTO TABLE stock
  3. FIELDS TERMINATED BY ','
  4. LINES TERMINATED BY '\n'
  5. IGNORE 1 ROWS
  6. (denumire,um,cod_bare,categorie,stoc,pret)

全部代码如下:

  1. $servername = "localhost";
  2. $username = "u831625604_a";
  3. $password = "Highschooldxd1";
  4. $db = "u831625604_a";
  5. $conn = new mysqli($servername, $username, $password , $db) or die("Connect failed: %s\n". $conn -> error);
  6. $sql = "CREATE TABLE IF NOT EXISTS `stock` (
  7. `denumire` VARCHAR(255),
  8. `um` VARCHAR(255),
  9. `cod_bare` VARCHAR(255),
  10. `categorie` VARCHAR(255),
  11. `stoc` VARCHAR(255),
  12. `pret`VARCHAR(255)
  13. );";
  14. $result = $conn->query($sql);
  15. $sql = "
  16. LOAD DATA INFILE '/home/u831625604/domains/andreiilinescu.com/public_html/stoc.csv'
  17. INTO TABLE stock
  18. FIELDS TERMINATED BY ','
  19. LINES TERMINATED BY '\n'
  20. IGNORE 1 ROWS
  21. (denumire,um,cod_bare,categorie,stoc,pret)
  22. ";

暂无答案!

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

相关问题