“在第1行‘？’附近使用的正确语法”错误。我正在使用node将csv数据导入mysql数据库

Question

export async function uploadcsv(req: Request, res: Response) {
try { 
  let stream = fs.createReadStream(req.file.path);
  let csvData:any = [];
  let csvStream = fastcsv
    .parse()
    .on("data", function(data:any) {
      csvData.push(data);
    })
    .on("end", function() {
      // remove the first line: header
      csvData.shift();
  
      // connect to the MySQL database
      // save csvData
    });      
  stream.pipe(csvStream);      
  const conn = await connect();   
  let query =
    "INSERT INTO sales9 (Transaction_date,Product,Price,Payment_Type,Name,City,State,Country,Account_Created,Last_Login,Latitude,Longitude) VALUES ?)"; 
  conn.execute(query, [csvData]) 
    .then((onfulfilled: any) => { 
      return res.status(200).json({
        message: "Successfully inserted"
      });
    })
    .catch(error => { 
      res.json({
        err: error
      });    
      throw error 
    });  

我正在使用nodejs和typescript将csv数据导入到MySQL-Server。

import { createPool } from "mysql2/promise";   

Answer 1

对于每个param，您需要与delcare中的列数相同的ov值和相同的vcar数

 "INSERT INTO sales9 (Transaction_date,Product,Price,Payment_Type,Name,City,State,Country,Account_Created,Last_Login,Latitude,Longitude) 
VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"; 
 conn.execute(query, csvData);

假定csvDatais有效数组的值正确，而不是字符串