Enter password: *********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| videoclub          |
| videojuegos        |
| world              |
+--------------------+
8 rows in set (0.00 sec)

mysql> create database UVM;
Query OK, 1 row affected (0.00 sec)

mysql> create table alumno(cuenta varchar(10) not null, nombre varchar(40) not null, telefono varchar(15) not null, email varchar(30) not null, nivel int unsigned not null, carrera varchar(5) not null, materia varchar(30) not null, calificacion int unsigned not null, promedio int unsigned not null);
ERROR 1046 (3D000): No database selected
mysql> use UVM
Database changed
mysql> create table alumno(cuenta varchar(10) not null, nombre varchar(40) not null, telefono varchar(15) not null, email varchar(30) not null, nivel int unsigned not null, carrera varchar(5) not null, materia varchar(30) not null, calificacion int unsigned not null, promedio int unsigned not null);
Query OK, 0 rows affected (0.31 sec)

mysql> create table docente(clave varchar(10) not null, nombre varchar(40) not null, telefono varchar(15) not null, email varchar(30) not null, profesion varchar(20) not null, grado int unsigned not null, materia varchar(30) not null, cuatrimestre int unsigned not null);
Query OK, 0 rows affected (0.19 sec)

mysql> insert into alumno(cuenta, nombre, telefono, email, nivel, carrera, materia, calificacion, promedio) values ('340319185','Santiago Garza','5543228522','sg@mail.com',3,'ISC','Bases de Datos',10,9);
Query OK, 1 row affected (0.05 sec)

mysql> insert into alumno(cuenta, nombre, telefono, email, nivel, carrera, materia, calificacion, promedio) values ('340311065','Alumno 2','7347232552','ratz@mail.com',2,'ISC','Bases de Datos',7,8);
Query OK, 1 row affected (0.05 sec)

mysql> insert into docente(clave, nombre, telefono, email, profesion, grado, materia, cuatrimestre) values ('D08217653','Javier','5585346798','docente@mail.com','Ing en Sistemas',3,'Bases de Datos',4);
Query OK, 1 row affected (0.02 sec)

mysql> insert into docente(clave, nombre, telefono, email, profesion, grado, materia, cuatrimestre) values ('D54643653','Docente 2','234346798','docente2@mail.com','Ing en Sistemas',2,'Bases de Datos',4);
Query OK, 1 row affected (0.05 sec)

mysql> select * from alumno;
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+
| cuenta    | nombre         | telefono   | email         | nivel | carrera | materia        | calificacion | promedio |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+
| 340319185 | Santiago Garza | 5543228522 | sg@mail.com   |     3 | ISC     | Bases de Datos |           10 |        9 |
| 340311065 | Alumno 2       | 7347232552 | ratz@mail.com |     2 | ISC     | Bases de Datos |            7 |        8 |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+
2 rows in set (0.00 sec)

mysql> select * from docente;
+-----------+-----------+------------+-------------------+-----------------+-------+----------------+--------------+
| clave     | nombre    | telefono   | email             | profesion       | grado | materia        | cuatrimestre |
+-----------+-----------+------------+-------------------+-----------------+-------+----------------+--------------+
| D08217653 | Javier    | 5585346798 | docente@mail.com  | Ing en Sistemas |     3 | Bases de Datos |            4 |
| D54643653 | Docente 2 | 234346798  | docente2@mail.com | Ing en Sistemas |     2 | Bases de Datos |            4 |
+-----------+-----------+------------+-------------------+-----------------+-------+----------------+--------------+
2 rows in set (0.00 sec)

mysql> select nombre from docente where (cuatrimestre=4);
+-----------+
| nombre    |
+-----------+
| Javier    |
| Docente 2 |
+-----------+
2 rows in set (0.00 sec)

mysql> select cuenta, nombre from docente where (carrera like 'ISC');
ERROR 1054 (42S22): Unknown column 'cuenta' in 'field list'
mysql> select cuenta, nombre from alumno where (carrera like 'ISC');
+-----------+----------------+
| cuenta    | nombre         |
+-----------+----------------+
| 340319185 | Santiago Garza |
| 340311065 | Alumno 2       |
+-----------+----------------+
2 rows in set (0.00 sec)

mysql> select *;
ERROR 1096 (HY000): No tables used
mysql> show tables;
+---------------+
| Tables_in_uvm |
+---------------+
| alumno        |
| docente       |
+---------------+
2 rows in set (0.00 sec)

mysql> drop table docente
    -> ;
Query OK, 0 rows affected (0.14 sec)

mysql> show tables;
+---------------+
| Tables_in_uvm |
+---------------+
| alumno        |
+---------------+
1 row in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| uvm                |
| videoclub          |
| videojuegos        |
| world              |
+--------------------+
9 rows in set (0.00 sec)

mysql> drop database videoclub;
Query OK, 1 row affected (0.13 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| uvm                |
| videojuegos        |
| world              |
+--------------------+
8 rows in set (0.00 sec)

mysql> alter table alumno ADD porcentaje_avance int unsigned not null;
Query OK, 0 rows affected (0.67 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> select * from alumno;
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
| cuenta    | nombre         | telefono   | email         | nivel | carrera | materia        | calificacion | promedio | porcentaje_avance |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
| 340319185 | Santiago Garza | 5543228522 | sg@mail.com   |     3 | ISC     | Bases de Datos |           10 |        9 |                 0 |
| 340311065 | Alumno 2       | 7347232552 | ratz@mail.com |     2 | ISC     | Bases de Datos |            7 |        8 |                 0 |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
2 rows in set (0.00 sec)

mysql> UPDATE alumno
    -> SET porcentaje_avance = 100
    -> WHERE promedio = 9;
Query OK, 1 row affected (0.05 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> UPDATE alumno
    -> SET porcentaje_avance = 80
    -> WHERE promedio = 8;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from alumno;
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
| cuenta    | nombre         | telefono   | email         | nivel | carrera | materia        | calificacion | promedio | porcentaje_avance |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
| 340319185 | Santiago Garza | 5543228522 | sg@mail.com   |     3 | ISC     | Bases de Datos |           10 |        9 |               100 |
| 340311065 | Alumno 2       | 7347232552 | ratz@mail.com |     2 | ISC     | Bases de Datos |            7 |        8 |                80 |
+-----------+----------------+------------+---------------+-------+---------+----------------+--------------+----------+-------------------+
2 rows in set (0.01 sec)

mysql>