Inserting data into a table
Inserting data with the INSERT command for testing queries.
In a production database, inserting columns and column values programmatically is more practical than using cqlsh, but often, being able to test queries using this SQL-like shell is very convenient.
To insert employee data for Jane Smith, use the INSERT command.
INSERT INTO emp (empID, deptID, first_name, last_name) VALUES (104, 15, 'jane', 'smith');
Attention: Be sure this document version matches your product version!