MySQL Codio

11. Final challenges

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.

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---------------------------------------Data Type------------------------ Null------------- key ---------------------------------------------------default

1) user_id -------------------------------- int (7) ---------------------- ----- NO---------- NO VALUE ---------------------------------------- NULL

2) email_frequency ------------------- tinyint (2) unsigned ------------ YES ----------NO VALUE ------------------------- ---------------- 15

3) layout ---------------------------------- varchar (70)--------------------- YES ------------NO VALUE- ----------------------------------------- vertical

4) updated-at --------------------------- datetime-------------------------- YES ------------NO VALUE -------------------------------------------- NULL