Convert Javascript Array to MySQL Array - Stack Overflow

admin管理员组

文章数量:1341390

i would like to convert a javascript array ids = [ 378, 464 ] to an array that MySQL is successfully parsing.

My SQL query includes the array like this:

Do something WHERE id IN ("472", "467"). 

This query works in MySQL Workbench.

I am struggling to get the array in the needed structure. I tried the following javascript structures within my api but i cannot get it to work.

("378", "464")
[ 378, 464 ]
('472', '467')

MYSQL Error Message:

  code: 'ER_PARSE_ERROR',
  errno: 1064,

i would like to convert a javascript array ids = [ 378, 464 ] to an array that MySQL is successfully parsing.

My SQL query includes the array like this:

Do something WHERE id IN ("472", "467"). 

This query works in MySQL Workbench.

I am struggling to get the array in the needed structure. I tried the following javascript structures within my api but i cannot get it to work.

("378", "464")
[ 378, 464 ]
('472', '467')

MYSQL Error Message:

  code: 'ER_PARSE_ERROR',
  errno: 1064,

• javascript
• mysql
• arrays
• api

Share Follow asked Sep 30, 2019 at 9:03 anderwaldanderwald 14933 silver badges99 bronze badges 2

• 1 where do you hand over the query? – Nina Scholz Commented Sep 30, 2019 at 9:08
• 1 You should also consider prepared statements - here's a way to deal with this for a variable-length IN clause: stackoverflow./questions/327274/… – cmbuckley Commented Sep 30, 2019 at 9:21

Add a ment  | 

4 Answers 4

Sorted by: Reset to default 6

You could stringify a stringed value and join all values with ma.

var ids = [378, 464],
    formatted = `(${ids.map(v => JSON.stringify(v.toString())).join(', ')})`;

console.log(formatted);

You can use Array#join('", "') to convert the array into the string format you desire.

var list = ["123", "354"];

if (!list.length) {
  console.log("Empty");
} else {
  var query = `select * from table where id in ("${list.join('", "')}")`;
  console.log(query);
}

Try Array.prototype.toString()

console.log("(",["378", "464"].toString(),")",);

Try it: Use join in array ("${arrItems.join('","')}")

var arrItems = [1,2,3,4,5,6,7,8,9];
var strSql = `SELECT * FROM Example WHERE ID IN ("${arrItems.join('","')}")`;
console.log(strSql);

本文标签： Convert Javascript Array to MySQL ArrayStack Overflow