Using INSERT, UPDATE, and DELETE with the Cassandra storage engine

Using a Cassandra storage engine table feels much like using any other table, but there are some important differences. This recipe demonstrates it.

Getting ready

We should complete the Mapping data between MariaDB and Cassandra recipe, before starting this recipe. Also, import the isfdb database as described in the Importing the data exported by mysqldump recipe in Chapter 2, Diving Deep into MariaDB, so that we have some data to use.

How to do it...

1. Open the mysql command-line client and connect to our MariaDB database server and then to the test database.

2. Insert some sample data into the test01_cass table, as follows:

   INSERT INTO test01_cass VALUES 
     ('rowkey10', 'data1-value', 123456), 
     ('rowkey11', 'data1-value2', 34543), 
     ('rowkey12', 'data1-value3', 444),
     ('rowkey13', 'data1-value4', 777666555);
   

3. Fill the empty notes_cass table with data from the isfdb.notes table using the following command:

   INSERT INTO notes_cass...