nodejs mysql 批量_【IT专家】NodeJS将批量值插入MySQL

本文由我司收集整编，推荐下载，如有疑问，请与我司联系

NodeJS将批量值插入MySQL

2016/01/19 75 I want to do a bulk insert to MYSQL table. According to this post, I’m using a 2D array. However, I kept getting MYSQL Syntax errors. Can anyone point me out?

?我想对MYSQL表进行批量插入。根据这篇文章，我正在使用2D阵列。但是，我一直收到MYSQL语法错误。有人能指出我吗？

Error:

?错误：

?You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NULL’ I have five columns in db, which has an auto-incrementing Id , update_date and create_date which I didn’t put in the insert query. For update_date and create_date I set it to on update CURRENT_TIMESTAMP

?我在db中有五列，它有一个自动递增的Id，update_date和create_date，我没有把它放在insert查询中。对于update_date和create_date，我将其设置为更新CURRENT_TIMESTAMP

?var insert = ‘INSERT INTO table2 (link, text) VALUES ?’;var res = [[‘google’, ‘google’],[‘bing’, ‘bing’]];var connection = mysql.createConnection({ host: ‘localhost’, user: ‘root’, password: ‘XXX’, database: ‘dbname’connection.connect();connection.query(insert, [res], function(err) { if (err) { console.log(err) connection.end(); throw err; connection.end(); 0

?Is the ‘default’ missing from your field definition ?

?字段定义中缺少“默认”吗？

?update_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMPtips:感谢大家的阅读，本文由我司收集整编。仅供参阅！