在SQL中读取csv文件

1 回答

• 1

  只要您可以连接到服务器，您就可以创建临时表 .

  对于Microsoft SQL;

  declare @TempTable csvtable 
       (
          firstCol varchar(50) NOT NULL,
          secondCol varchar(50) NOT NULL
       )
  
  BULK INSERT @TempTable FROM 'PathToCSVFile' WITH (FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
  
  GO
  

  对于MySQL;

  CREATE TEMPORARY TABLE csvtable
  
  LOAD DATA INFILE 'PathToCSVFile' 
  INTO TABLE csvtable 
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\n'
  IGNORE 1 ROWS;
  

  回复于 2024-04-25T10:31:38+08:00