1. Use the table that was imported into the "miagenda" database and modify its structure by adding two (2) additional fields and add the following data corresponding to the table:

• Email varchar(50)
• TownResidence varchar(50)

1. Create a SQL script in the phpMyAdmin environment to display all the fields in the table, including the created fields.
2. Use phpMyAdmin and export the data in ".txt" format. Use a text editor, for example Notepad , to access the exported file, and verify that all the data is correct. Save them in a file called Task5-2.txt and send it to the teacher including a screenshot.

 

Transcribed Image Text:

# Name 1 IDpersonal 2 Nombre 3 Apellido 4 Edad 5 Telefono Type int(11) Collation varchar(15) utf8mb4_general_ci varchar(15) utf8mb4_general_ci int(11) int(15) Attributes Null Default Comments Extra No None No None No None No None None No Action AUTO INCREMENT Change Drop More Drop More Change Change Drop More Change Drop More Change Drop More # Name 1 IDpersonal 2 Nombre 3 Apellido 4 Edad 5 Telefono Type int(11) Collation varchar(15) utf8mb4_general_ci varchar(15) utf8mb4_general_ci int(11) int(15) Attributes Null Default Comments Extra No None No None No None No None None No Action AUTO INCREMENT Change Drop More Drop More Change Change Drop More Change Drop More Change Drop More