首页
开发手册
应用中心
工具
用户中心
DBM Data Addition, Deletion, Modification and Investigation
English
中文简体
English
上一篇
下一篇
### Adding, Deleting, Modifying and Checking DBM Data This chapter explains how to use DBM to add, modify, delete, and view operations. #### 1. Insert Data Select the table to be operated, click to insert data, fill in the corresponding value according to the field, and click to execute to insert the database ![](data/files/edit/21/06/19/210619_15596452.png) --- #### 2.Change the Data You can double-click the content that needs to be modified in the query list to modify, or you can edit a piece of data **2.1 Double-click to edit** ![](data/files/edit/21/06/19/210619_16027256.png) **2.2 Modification by editing function** ![](data/files/edit/21/06/19/210619_16021228.png) --- #### 3.Delete Data **`Data is precious, you need to be careful when deleting it`** **3.1 Single delete, select a data, click delete** ![](data/files/edit/21/06/19/210619_16072505.png) **3.2 Delete in batches, tick the data to be deleted, and click the delete button in the upper left corner.** ![](data/files/edit/21/06/19/210619_16103887.png) **3.3 To clear the data table, in the data table management, select the data table that needs to be cleared, and click Clear. ** ![](data/files/edit/21/06/19/210619_16127238.png) --- #### 4.Search Data Select the table you want to query in the data table management, click search, and select the search method (operator) for a certain field to search. ![](data/files/edit/21/06/19/210619_17231841.png) ** Search Query Operator Description ** | Usage | Description | | ------ | ------ | | = | Data exactly equal to the query conditions | | >= |Data greater than or equal to the query conditions, generally used for numeric queries | | <= | Data less than or equal to the query conditions, generally used for numeric query | |> | Data larger than the query condition, generally used for digital query | | <| Data smaller than the query condition, generally used for digital query | | != | Data not equal to query conditions | | LIKE | Data equal to query conditions, generally used for character query | | LIKE %...% | Fuzzy query of data between %, generally used for character query | | NOT LIKE | Data not equal to query conditions, generally used for character query | | IN (...) | Data equal to multiple sets of query conditions, separated by commas | | NOT IN (...) | Data not equal to multiple query conditions, separated by commas |