mysql in查询传入数组,使用“ IN”传递数组作为要在SQL查询中使用的参数。命令...

Good Afternoon to All,

I have a question concerning on SQL Queries. is it possible to use an array as a parameter to a query using the "IN" command?

for example,

int x = {2,3,4,5}

UPDATE 'table_name' set 'field' = data WHERE field_ID IN (x)

the reason I am asking this is to avoid an iterative SQL Statement when I have to update data in a database.

I also thought of using a for each statement in for the UPDATE Query but I don't know if it will affect the performance of the query if it will slow down the system if ever 100+ records are updated.

I am using VB.Net btw.

My Database is MySQL Workbench.

解决方案

I have gotten the answer. I just simply need to convert each elements to a String then concatenate it with a "," for each element. so the parameter that i will pass will be a string.

ANSWER:

int x = {2,3,4,5}

will become

string x = "2,3,4,5"

My Query string will become "UPDATE tablename SET field=value WHERE ID IN("&x&")"

Thank you to all who helped.