mysql查询条件

2024-02-15 17:12:52

```sql

SELECT supplier_name

FROM equipment_supply

WHERE device_type = '目标设备类型';

```

```sql

SELECT product_name

FROM agriculture

WHERE origin = '目标产地';

```

```sql

SELECT patent_name

FROM patent_application

WHERE applicant = '目标申请人';

```

```sql

SELECT device_model

FROM energySaving_equipment

WHERE energy_rating = '级';

```