nodejs mysql 参数_使用nodejs更新mysql的表，SET后面的参数不固定，请问如何实现？...

我想写一个更新用户信息的接口，

UPDATE user_information SET 这里的参数不固定 where uid = ?

有可能是 name=? 或者 name=?, sex=? 或者 name=?, sex=?, qq=?

请怎么我应该如何实现？

app.all("/information/update", (req, res, next) => {

let sess = req.session;

let result = {

code: "0000",

data: {},

message: "fail",

detail: "",

function: "prize",

number: 0

};

let params = req.body;

let selectSql = "select name from user_information where uid = ?";

let updateSql = "UPDATE user_information SET name=? where uid = ?";

let name = helper.stringTrim(params.name) || "";

if(sess.loginUserInfo === undefined) {

result["detail"] = "用户没有登陆";