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',
'[email protected]',
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, andencrypted_passwordFinally, we provide the values to insert into those columns, in the same order that the column names were listed previously