Inserting, updating, and deleting data

For DSE Search, inserting and updating data uses the same CQL statements like any update to the database.

Updates to a CQL-based search index replaces the entire row. You cannot replace only a field in a CQL table.

To update a CQL-based search index:

Building on the Querying CQL collections example, insert data into mykeyspace.mysolr and the search index.
```
INSERT INTO mykeyspace.mysolr ('id', 'quotes', 'name', 'title') VALUES ('130', 'Life is a beach', 'unknown', 'Life');
```
When using CQL to update a field, DSE Search implicitly updates individual fields in the Solr document. The reindexing of data occurs automatically.

Was this helpful?