Shulou(Shulou.com)06/02 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.