I have A table department table B table employee table
SelectByid is according to the department ID to check staff
Such as Byid=1 out of a set of employee Byid=2 out another group
So the question is
If I have Byid 1 and 2 is out at the same time employees have one and again 2 to do

CodePudding user response:

Byid in (1, 2)

CodePudding user response:

The

reference 1/f, February 16 response:

Byid in (1, 2)

I do this is the interface id returned to the front

CodePudding user response:

The front-end interface parameter List Or an array of
Backend will be changed to string 1, 2 this form
Select * from table where byid in (1, 2)
Can
Spell string, because the participation is plastic array, so there would be no injection problem

There are, of course, not a string, using dynamic parameters, table-valued parameter, is the point of trouble