MySQL Database Activity 2

MySQL Database Activity 2

This activity will test your knowledge on basic sql statements. To review our MySQL Lessons and Tutorials, kindly visit this link MySQL Tutorials Compilation. The answers can be found on our facebook page or you can download the answers here.

1. Write the complete SQL statement for creating a new database called contacts.

2. How would you list all the databases available on the system?

3. Create a table called contacts_data with the following field:id, firstname, lastname, age, email, address, contact_number. Apply the appropriate data type.

4. Issue the command that will list the information of the table.

5. Write the statement for inserting the following data in contacts_data table.

6. Give two forms of the SELECT statement that will list all the data in contacts_data table

7. Write the statement for inserting the following data in contacts_data table in a single query.

Pascual, Milby, 36, abc@yahoo.com, Vito, 123456
Sam, Ondoy, 45, sam@yahoo.com, Escalante, 654321
Angel, Algara, 24, angel@yahoo.com, Escalante, 09293831491

8. Write the SQL statement to update the age into 23 and the email into sample@facebook.com where their address is Vito.

9. Write the SQL statement to delete the record whose age is greater than 35.

10. Write the SELECT statement to extract the firstname and email whose address is Escalante

11.Display the records (last names followed by first names) whose address is either “Vito” or “North Pole” and sort their name in descending order

12. Order the records on the basis of their age (ascending).

13. Write the SQL statement that will select the unique value in the field of address.

14. List all ids and lastname between 33 and 40 years of age.

15. Issue the command to extract the next two records starting with the first row.

 

, , , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.