MariaDB [libreria]> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (10061)
ERROR: Can't connect to the server

unknown [libreria]> show tables;
No connection. Trying to reconnect...
Connection id:    8
Current database: libreria

+--------------------+
| Tables_in_libreria |
+--------------------+
| autor              |
| editorial          |
| liautedi           |
| libro              |
| materia            |
+--------------------+
5 rows in set (0.040 sec)

MariaDB [libreria]> describe materia;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| codigomat | varchar(20) | NO   | PRI | NULL    |       |
| nombre    | varchar(60) | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.083 sec)

MariaDB [libreria]> select * from materia;
+-----------+-------------+
| codigomat | nombre      |
+-----------+-------------+
| M01       | matematicas |
+-----------+-------------+
1 row in set (0.164 sec)

MariaDB [libreria]> delete from materia where codigomat = 'M01';
Query OK, 1 row affected (0.167 sec)

MariaDB [libreria]> select * from materia;
Empty set (0.001 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M01','Calculo');
Query OK, 1 row affected (0.150 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M02','Matematicas');
Query OK, 1 row affected (0.102 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M03','Estructura de datos');
Query OK, 1 row affected (0.101 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M04','Ingles');
Query OK, 1 row affected (0.105 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M08','Diagramacion');
Query OK, 1 row affected (0.108 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M06','Contabilidad');
Query OK, 1 row affected (0.091 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M07','Redes');
Query OK, 1 row affected (0.126 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M05','Sistemas de inf.');
Query OK, 1 row affected (0.078 sec)

MariaDB [libreria]> insert into materia (codigomat, nombre) values ('M09','Base de datos');
Query OK, 1 row affected (0.097 sec)

MariaDB [libreria]> select * from materia;
+-----------+---------------------+
| codigomat | nombre              |
+-----------+---------------------+
| M01       | Calculo             |
| M02       | Matematicas         |
| M03       | Estructura de datos |
| M04       | Ingles              |
| M05       | Sistemas de inf.    |
| M06       | Contabilidad        |
| M07       | Redes               |
| M08       | Diagramacion        |
| M09       | Base de datos       |
+-----------+---------------------+
9 rows in set (0.002 sec)

MariaDB [libreria]> select * from libro;
Empty set (0.002 sec)

MariaDB [libreria]> show describe table libro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'table libro' at line 1
MariaDB [libreria]> show describe libro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'libro' at line 1
MariaDB [libreria]> show create libro;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'libro' at line 1
MariaDB [libreria]> show create table libro;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                           |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| libro | CREATE TABLE `libro` (
  `idlibro` varchar(20) NOT NULL,
  `titulo` varchar(60) NOT NULL,
  `nropagina` int(11) NOT NULL,
  `precio` int(11) NOT NULL,
  `codigomat` varchar(20) NOT NULL,
  PRIMARY KEY (`idlibro`),
  KEY `codigomat` (`codigomat`),
  CONSTRAINT `libro_ibfk_1` FOREIGN KEY (`codigomat`) REFERENCES `materia` (`codigomat`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L01','Calculo II',120,55000,'M01');
Query OK, 1 row affected (0.101 sec)

MariaDB [libreria]> select * from libro;
+---------+------------+-----------+--------+-----------+
| idlibro | titulo     | nropagina | precio | codigomat |
+---------+------------+-----------+--------+-----------+
| L01     | Calculo II |       120 |  55000 | M01       |
+---------+------------+-----------+--------+-----------+
1 row in set (0.001 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L02','BD II',150,65000,'M09');
Query OK, 1 row affected (0.171 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L03','Estructura de datos',180,85000,'M03');
Query OK, 1 row affected (0.198 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L08','Diagramacion',85,45000,'M08');
Query OK, 1 row affected (0.081 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L05','Admon en una pagina',70,7500,'M05');
Query OK, 1 row affected (0.105 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L05','Admon en una pagina',70,27500,'M06');
ERROR 1062 (23000): Duplicate entry 'L05' for key 'PRIMARY'
MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L06','Contabilidad I',170,27500,'M06');
Query OK, 1 row affected (0.184 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L07','Redes',370,32500,'M07');
Query OK, 1 row affected (0.167 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L04','Ingles',280,105000,'M04');
Query OK, 1 row affected (0.164 sec)

MariaDB [libreria]> insert into libro (idlibro,titulo,nropagina,precio,codigomat) values ('L24','ExtraPrueba',280,105000,'M04');
Query OK, 1 row affected (0.189 sec)

MariaDB [libreria]> select * from libro;
+---------+---------------------+-----------+--------+-----------+
| idlibro | titulo              | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L05     | Admon en una pagina |        70 |   7500 | M05       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
| L07     | Redes               |       370 |  32500 | M07       |
| L08     | Diagramacion        |        85 |  45000 | M08       |
| L24     | ExtraPrueba         |       280 | 105000 | M04       |
+---------+---------------------+-----------+--------+-----------+
9 rows in set (0.001 sec)

MariaDB [libreria]> delete from libro where idlibro = 'L24';
Query OK, 1 row affected (0.066 sec)

MariaDB [libreria]> select * from libro;
+---------+---------------------+-----------+--------+-----------+
| idlibro | titulo              | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L05     | Admon en una pagina |        70 |   7500 | M05       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
| L07     | Redes               |       370 |  32500 | M07       |
| L08     | Diagramacion        |        85 |  45000 | M08       |
+---------+---------------------+-----------+--------+-----------+
8 rows in set (0.001 sec)

MariaDB [libreria]> select * from lautedi;
ERROR 1146 (42S02): Table 'libreria.lautedi' doesn't exist
MariaDB [libreria]> show tables;
+--------------------+
| Tables_in_libreria |
+--------------------+
| autor              |
| editorial          |
| liautedi           |
| libro              |
| materia            |
+--------------------+
5 rows in set (0.002 sec)

MariaDB [libreria]> select * from liautedi;
Empty set (0.002 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A01','Luis Joyanes');
Query OK, 1 row affected (0.230 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A02','Jorge Vasquez Posada');
Query OK, 1 row affected (0.156 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A03','Jhon Soars');
Query OK, 1 row affected (0.158 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A04','Riaz Khadem');
Query OK, 1 row affected (0.201 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A05','Robert Lorber');
Query OK, 1 row affected (0.169 sec)

MariaDB [libreria]> insert into autor (codautor,nombre) values ('A06','Mario Dream');
Query OK, 1 row affected (0.190 sec)

MariaDB [libreria]> select * from autor;
+----------+----------------------+
| Codautor | nombre               |
+----------+----------------------+
| A01      | Luis Joyanes         |
| A02      | Jorge Vasquez Posada |
| A03      | Jhon Soars           |
| A04      | Riaz Khadem          |
| A05      | Robert Lorber        |
| A06      | Mario Dream          |
+----------+----------------------+
6 rows in set (0.017 sec)

MariaDB [libreria]> insert into editorial (codedit,nombre) values ('E01','Oveja Negra');
Query OK, 1 row affected (0.197 sec)

MariaDB [libreria]> insert into editorial (codedit,nombre) values ('E02','Norma');
Query OK, 1 row affected (0.092 sec)

MariaDB [libreria]> insert into editorial (codedit,nombre) values ('E03','Mc Graw Hill');
Query OK, 1 row affected (0.152 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L02','A01','E01');
Query OK, 1 row affected (0.289 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L02','A05','E03');
Query OK, 1 row affected (0.163 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L06','A02','E02');
Query OK, 1 row affected (0.045 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L07','A05','E03');
Query OK, 1 row affected (0.135 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L04','A04','E01');
Query OK, 1 row affected (0.138 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L04','A04','E02');
Query OK, 1 row affected (0.143 sec)

MariaDB [libreria]> insert into liautedi (idlibro,codautor,codedit) values ('L04','A04','E03');
Query OK, 1 row affected (0.172 sec)

MariaDB [libreria]> select * from liautedi;
+---------+----------+---------+
| idlibro | codautor | codedit |
+---------+----------+---------+
| L02     | A01      | E01     |
| L02     | A05      | E03     |
| L06     | A02      | E02     |
| L07     | A05      | E03     |
| L04     | A04      | E01     |
| L04     | A04      | E02     |
| L04     | A04      | E03     |
+---------+----------+---------+
7 rows in set (0.002 sec)

MariaDB [libreria]> select titulo from libro
    -> ;
+---------------------+
| titulo              |
+---------------------+
| Calculo II          |
| BD II               |
| Estructura de datos |
| Ingles              |
| Admon en una pagina |
| Contabilidad I      |
| Redes               |
| Diagramacion        |
+---------------------+
8 rows in set (0.001 sec)

MariaDB [libreria]> select nombre from autor;
+----------------------+
| nombre               |
+----------------------+
| Luis Joyanes         |
| Jorge Vasquez Posada |
| Jhon Soars           |
| Riaz Khadem          |
| Robert Lorber        |
| Mario Dream          |
+----------------------+
6 rows in set (0.001 sec)

MariaDB [libreria]> select nombre from editorial;
+--------------+
| nombre       |
+--------------+
| Oveja Negra  |
| Norma        |
| Mc Graw Hill |
+--------------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select * from materia;
+-----------+---------------------+
| codigomat | nombre              |
+-----------+---------------------+
| M01       | Calculo             |
| M02       | Matematicas         |
| M03       | Estructura de datos |
| M04       | Ingles              |
| M05       | Sistemas de inf.    |
| M06       | Contabilidad        |
| M07       | Redes               |
| M08       | Diagramacion        |
| M09       | Base de datos       |
+-----------+---------------------+
9 rows in set (0.001 sec)

MariaDB [libreria]> select nombre from materia;
+---------------------+
| nombre              |
+---------------------+
| Calculo             |
| Matematicas         |
| Estructura de datos |
| Ingles              |
| Sistemas de inf.    |
| Contabilidad        |
| Redes               |
| Diagramacion        |
| Base de datos       |
+---------------------+
9 rows in set (0.001 sec)

MariaDB [libreria]> select * from libro;
+---------+---------------------+-----------+--------+-----------+
| idlibro | titulo              | nropagina | precio | codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | Calculo II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | Estructura de datos |       180 |  85000 | M03       |
| L04     | Ingles              |       280 | 105000 | M04       |
| L05     | Admon en una pagina |        70 |   7500 | M05       |
| L06     | Contabilidad I      |       170 |  27500 | M06       |
| L07     | Redes               |       370 |  32500 | M07       |
| L08     | Diagramacion        |        85 |  45000 | M08       |
+---------+---------------------+-----------+--------+-----------+
8 rows in set (0.001 sec)

MariaDB [libreria]> select titulo,nropagina,precio from libro;
+---------------------+-----------+--------+
| titulo              | nropagina | precio |
+---------------------+-----------+--------+
| Calculo II          |       120 |  55000 |
| BD II               |       150 |  65000 |
| Estructura de datos |       180 |  85000 |
| Ingles              |       280 | 105000 |
| Admon en una pagina |        70 |   7500 |
| Contabilidad I      |       170 |  27500 |
| Redes               |       370 |  32500 |
| Diagramacion        |        85 |  45000 |
+---------------------+-----------+--------+
8 rows in set (0.002 sec)

MariaDB [libreria]> alter table materia rename to asignatura;
Query OK, 0 rows affected (0.352 sec)

MariaDB [libreria]> show tables;
+--------------------+
| Tables_in_libreria |
+--------------------+
| asignatura         |
| autor              |
| editorial          |
| liautedi           |
| libro              |
+--------------------+
5 rows in set (0.002 sec)

MariaDB [libreria]> notee