src/zh/UserGuide/latest-Table/Basic-Concept/Delete-Data.md

<!--

    Licensed to the Apache Software Foundation (ASF) under one
    or more contributor license agreements.  See the NOTICE file
    distributed with this work for additional information
    regarding copyright ownership.  The ASF licenses this file
    to you under the Apache License, Version 2.0 (the
    "License"); you may not use this file except in compliance
    with the License.  You may obtain a copy of the License at
    
        http://www.apache.org/licenses/LICENSE-2.0
    
    Unless required by applicable law or agreed to in writing,
    software distributed under the License is distributed on an
    "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
    KIND, either express or implied.  See the License for the
    specific language governing permissions and limitations
    under the License.

-->

# 数据删除

## 1. 数据删除

数据删除可以通过 delete 语句来完成，其中可以通过指定标签和时间的过滤条件来删除部分数据。

注意：
常规的数据删除命令 （DELETE FROM 语句）执行后不会立即释放磁盘空间，而是先对数据进行标记，依靠后台任务逐步地去释放空间。
调小参数 `inner_compaction_task_selection_disk_redundancy` 和 `inner_compaction_task_selection_mods_file_threshold` 可以加快该过程。
删除数据库命令（DROP DATABASE 语句）可以立即释放磁盘空间。

### 1.1 语法概览

```SQL
DELETE FROM <TABLE_NAME> [WHERE_CLAUSE]?

WHERE_CLAUSE:
    WHERE DELETE_CONDITION

DELETE_CONDITION:
    SINGLE_CONDITION
    | DELETE_CONDITION AND DELETE_CONDITION
    | DELETE_CONDITION OR DELETE_CONDITION

SINGLE_CODITION:
    TIME_CONDITION | ID_CONDITION

TIME_CONDITION:
    time TIME_OPERATOR LONG_LITERAL

TIME_OPERATOR:
    < | > | <= | >= | =

ID_CONDITION:
    identifier = STRING_LITERAL
```

- 当前仅支持时间条件和标签条件，条件之间仅可使用 AND 和 OR 运算符连接。
- 对于时间条件，支持 >、<、=、<=、>= 五种运算符。
- 对于标签条件，目前仅支持 = 运算符。

### 1.2 示例

可以在[示例数据页面](../Reference/Sample-Data.md)中导入示例数据。可以使用这些数据来测试和执行示例中的SQL语句。

#### 1.2.1 删除全表数据

```SQL
# 全表删除
DELETE FROM table1
```

#### 1.2.2 删除一段时间范围

```SQL
# 单时间段删除
DELETE FROM table1 WHERE time <= 2024-11-29 00:00:00

# 多时间段删除
DELETE FROM table1  WHERE time >= 2024-11-27 00:00:00  and time <= 2024-11-29 00:00:00
```

#### 1.2.3 删除指定设备

```SQL
# 删除指定设备
# 标识条件只支持 = 运算符
DELETE FROM table1 WHERE device_id='101' and model_id = 'B'

# 删除指定设备的时间段
DELETE FROM table1 
    WHERE time >= 2024-11-27 16:39:00  and time <= 2024-11-29 16:42:00 
    AND device_id='101' and model_id = 'B'

# 删除指定类型的设备
DELETE FROM table1 WHERE model_id = 'B'
```

## 2. 设备删除

设备删除语句支持删除表里所有设备及相关数据。

### 2.1 语法概览

```SQL
DELETE DEVICES FROM tableName=qualifiedName (WHERE booleanExpression)?
```

- WHERE 仅支持对标签的等值过滤，条件之间仅可使用 AND 和 OR 运算符连接，不支持时间条件。

### 2.2 示例

```SQL
DELETE DEVICES FROM table1 WHERE device_id = '101'
```