sql语句中使用数组一行代码解决sql语句

导读--数组vararrs=['test1','test2','test3'];--变字符串varinstring="'"arrs.join("','")"'"....

--数组

var arrs= [test1,test2,test3];

--变字符串

var instring = "" arrs.join(",") "";

--拼接

var sql = "select * from table where CreateUser in (" instring ")";

--结果

select * from table where CreateUser in (test1,test2,test3)

意外金喜的博客 : http://blog.csdn.net/zzwwjjdj1/