Can in support multiple fields in mysql?

This article mainly explains "can in support multiple fields in mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "can in support multiple fields in mysql?"

Basic usage

Select * from user where user_id in (600601602)

Use multiple fields at the same time

Select * from user where (user_id,type) in (568, 6), (569, 6), (600, 8))

Use of multiple tables and multiple fields at the same time

Select * from user where (legal_id,type) not in (select a.legalprincipid.type from user as a, role_user_relation as b where a.legal_id=b.legal_id and a.type=b.legal_type) limit 0re10 SELECT Department.name AS 'Department', Employee.name AS' Employee', SalaryFROM Employee JOIN Department ON Employee.DepartmentId = Department.IdWHERE (Employee.DepartmentId, Salary) IN (SELECT DepartmentId, MAX (Salary) FROM Employee GROUP BY DepartmentId) so far, I believe you have a deeper understanding of "can in support multiple fields in mysql?" Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!