Inserting data

For our status-sharing application, the first thing we'll want any user to do is to create an account. We'll ask them to choose a username column, enter their email column, and pick a password column; our business logic will be responsible for ensuring that the entries are valid and for encrypting the password appropriately. At that point, we'll be ready to insert the account information as a new row in the users table:

 INSERT INTO "users"
 ("username", "email", "encrypted_password")
 VALUES (
   'alice',
   'alice@gmail.com',
   0x8914977ed729792e403da53024c6069a9158b8c4
 );

In the previous statement, which should be familiar to anyone who has used an SQL database, we provide the following information:

• We want to add a row to the users table
• We'll be adding data to three columns in that row: username, email, and encrypted_password
• Finally, we provide the values to insert into those columns in the same order that the column names were listed previously

Does whitespace matter?
CQL is agnostic about whitespace. The query as written uses a lot of newlines for readability, but the query would be just as valid written on a single line.

Type the preceding CQL statement into your Cassandra shell (don't forget about the semicolon at the end!) Did it work? At first glance, it may be hard to tell.