如何使用Node.js更新MySQL中的多列 [英] How to update multiple columns in mysql using nodejs

问题描述

如何使用node.js更新MySQL中的多列:

How to update the multiple columns in MySQL using node.js:

var query = 'UPDATE employee SET profile_name = ? WHERE id = ?';
connection.query(query,[req.name,req.id] function (error, result, rows, fields) {

但是我必须立即更新profile_name，phone,email，country，state，address.
任何人都可以建议我该怎么做.

but I have to update profile_name, phone,email, country, state, address at once.
How can I do that, can anyone suggest.

推荐答案

只需添加集合中的所有列:

Simply add all columns in set:

var query = 'UPDATE employee SET profile_name = ?, phone =?, .. WHERE id=?';

connection.query(query,[req.name,req.phone,...,req.id] function (error, result, rows, fields) {

这篇关于如何使用Node.js更新MySQL中的多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！