Database Reference
In-Depth Information
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, enter their email, and pick a password; 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 data-
base, 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
en-
crypted_password
• Finally, we provide the values to insert into those columns, in the same order that
the column names were listed previously
Note
Does whitespace matter?
CQL is agnostic about whitespace. The query as written uses a lot of newlines for readabil-
ity, 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 semi-
colon at the end!) Did it work? At first glance, it may be hard to tell.
