SELECT *
FROM table_name
WHERE 条件1 and 条件2;
SELECT *
FROM table_name
WHERE 条件1 and 条件2 or 条件;
SELECT *
FROM table_name
WHERE (字段名1,字段名2)=(值1,值2);
SQL的多条件查询语句
最新推荐文章于 2024-05-23 04:02:55 发布
SELECT *
FROM table_name
WHERE 条件1 and 条件2;
SELECT *
FROM table_name
WHERE 条件1 and 条件2 or 条件;
SELECT *
FROM table_name
WHERE (字段名1,字段名2)=(值1,值2);