the problem for Mysql

[hanx...@qq.com]

in my project.i use mysql like this:

var user = {
    getAllUserList:'select * from ad_user where name = ? and address = ?'
}

and i can get result list this:

var query = connection.query(user.select,[param.name,param.address],function(err,result){

    if(result){
      ....
    }
});

but if i only have one parameter,Name or addresss.How to write the sql.

Regards,

Jiff Han 

[Ryan Schmidt]

Well, if you only have the parameter "name", then the SQL would be "SELECT * FROM ad_user WHERE name = ?" and you would invoke connection.query(user.select, [param.name], function (err, result) {...});

[梁少峰]

What about define two sql query? One for select name,anthor for select address.

You can choose which sql query to use according to the param.

May it help.

在 2016年1月8日星期五 UTC+8下午1:29:07，hanx...@qq.com写道：