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',
   '[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, and encrypted_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...