MySQL

FINAL CHALLENGE

User settings are another example of data that needs to be updated. Users often decide to change their username, password, email accounts, email notification frequency and so on.

Complete the final challenges and evaluate your understanding of the UPDATE, ALTER and RENAME SQL keywords.

User settings

A mysql> prompt has been opened for you.

Complete the following SQL statements (try using dot syntax):

1 - Create an App database

2 - Use the App database and create a settings table with these features:

+-----------------+---------------------+------+-----+----------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+----------+-------+ | user_id | int(7) | NO | | NULL | | | email_frequency | tinyint(2) unsigned | YES | | 15 | | | layout | varchar(70) | YES | | vertical | | | updated_at | datetime | YES | | NULL | | +-----------------+---------------------+------+-----+--------