-index
parameter is not specified, all records that meet the condition will be deleted from the table.delete from table where key1 = 1 and key2 = "abc" [and -index = 1] [by partkey];
Parameter | Protobuf | TDR | Required |
table | Table name | Table name | Yes |
key | Primary key field name. All key values are required. | Primary key field name. All key values are required. | Yes |
value | Non-primary key field name | Non-primary key field name | Yes, at least one field name is required. |
-index | LIST table: you must specify \\-index . Only the specified record will be replaced.GENERIC table: not supported | LIST table: if \\-index is specified, the index-th record with the same key will be returned; if \\-index is not specified, all records will be returned.GENERIC table: not supported | No |
by partkey | Not supported | LIST table: not supported GENERIC table: delete records by partial keys | No |
tcaplus> delete from table_list where uin=99 and name = "99" and key1=99 and -index=0;delete successdelete time: 10263 ustcaplus> delete from table_generic_xiahuaxian where _uin=99 and name = "danmi_test_1" and _key3=4 by partkey;delete successdelete time: 14405 us
Was this page helpful?