MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| libreria           |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
7 rows in set (0.171 sec)

MariaDB [(none)]> drop database libreria;
Query OK, 5 rows affected (0.754 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.001 sec)

MariaDB [(none)]> create database libreria;
Query OK, 1 row affected (0.035 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| libreria           |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
7 rows in set (0.001 sec)

MariaDB [(none)]> use libreria;
Database changed
MariaDB [libreria]> create table Libro
    -> (Idlibro varchar(50) not null primary key,
    -> Titulo varchar(50) not null,
    -> Nropagina int not null,
    -> Precio int not null,
    -> Codigomat varchar(50) not null);
Query OK, 0 rows affected (0.213 sec)

MariaDB [libreria]> alter table Libro change Titulo Descripcion varchar(50) not null;
Query OK, 0 rows affected (0.108 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [libreria]> show tables;
+--------------------+
| Tables_in_libreria |
+--------------------+
| libro              |
+--------------------+
1 row in set (0.002 sec)

MariaDB [libreria]> describe libro;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| Idlibro     | varchar(50) | NO   | PRI | NULL    |       |
| Descripcion | varchar(50) | NO   |     | NULL    |       |
| Nropagina   | int(11)     | NO   |     | NULL    |       |
| Precio      | int(11)     | NO   |     | NULL    |       |
| Codigomat   | varchar(50) | NO   |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.150 sec)

MariaDB [libreria]> create table Materia
    -> (Codigomat varchar(50) not null,
    -> Nombre varchar(50) not null);
Query OK, 0 rows affected (0.097 sec)

MariaDB [libreria]> show tables;
+--------------------+
| Tables_in_libreria |
+--------------------+
| libro              |
| materia            |
+--------------------+
2 rows in set (0.001 sec)

MariaDB [libreria]> alter table Materia rename to Asignatura;
Query OK, 0 rows affected (0.055 sec)

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

MariaDB [libreria]> describe asignatura;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Codigomat | varchar(50) | NO   |     | NULL    |       |
| Nombre    | varchar(50) | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.068 sec)

MariaDB [libreria]> create table Autor
    -> (Codautor varchar(50) not null primary key,
    -> Nombre varchar(50) not null);
Query OK, 0 rows affected (0.155 sec)

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

MariaDB [libreria]> describe autor;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Codautor | varchar(50) | NO   | PRI | NULL    |       |
| Nombre   | varchar(50) | NO   |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.081 sec)

MariaDB [libreria]> create table Editorial
    -> (Codedit varchar(50) not null primary key,
    -> Nombre varchar(50) not null);
Query OK, 0 rows affected (0.066 sec)

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

MariaDB [libreria]> describe editorial;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Codedit | varchar(50) | NO   | PRI | NULL    |       |
| Nombre  | varchar(50) | NO   |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.169 sec)

MariaDB [libreria]> create table Liautedi
    -> (Idlibro varchar(50) not null,
    -> Codautor varchar(50)not null,
    -> Codedit varchar(50) not null,
    -> foreign key(Idlibro) references Libro(Idlibro) on delete cascade on update cascade,
    -> foreign key(Codautor) references Autor(Codautor) on delete cascade on update cascade,
    -> foreign key(Codedit) references Editorial(Codedit) on delete cascade on update cascade);
Query OK, 0 rows affected (0.116 sec)

MariaDB [libreria]> describe Liautedi;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Idlibro  | varchar(50) | NO   | MUL | NULL    |       |
| Codautor | varchar(50) | NO   | MUL | NULL    |       |
| Codedit  | varchar(50) | NO   | MUL | NULL    |       |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.103 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L01','CALCULO II',120,55000,'M01');
Query OK, 1 row affected (0.008 sec)

MariaDB [libreria]> select *from libro;
+---------+-------------+-----------+--------+-----------+
| Idlibro | Descripcion | Nropagina | Precio | Codigomat |
+---------+-------------+-----------+--------+-----------+
| L01     | CALCULO II  |       120 |  55000 | M01       |
+---------+-------------+-----------+--------+-----------+
1 row in set (0.003 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L02','BD II',150,65000,'M09');
Query OK, 1 row affected (0.023 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L03','ESTRUCTURA DE DATOS',180,85000,'M03');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L08','DIAGRAMACION',85,45000,'M08');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L05','ADMON EN UNA PAGINA',70,7500,'M05');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L06','CONTABILIDAD I',170,27500,'M06');
Query OK, 1 row affected (0.003 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L07','REDES',370,32500,'M07');
Query OK, 1 row affected (0.025 sec)

MariaDB [libreria]> insert into Libro(Idlibro,Descripcion,Nropagina,Precio,Codigomat) values('L04','INGLES',280,105000,'M04');
Query OK, 1 row affected (0.099 sec)

MariaDB [libreria]> select * from libro;
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | 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]> insert into Asignatura(Codigomat,Nombre) values('M01','CALCULO');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> select *from asignatura;
+-----------+---------+
| Codigomat | Nombre  |
+-----------+---------+
| M01       | CALCULO |
+-----------+---------+
1 row in set (0.001 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M02','MATEMATICAS');
Query OK, 1 row affected (0.063 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M03','ESTRUCTURA DE DATOS');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M04','INGL');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M08','DIAGRAAMACION');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M06','CONTABILIDAD');
Query OK, 1 row affected (0.007 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M07','REDES');
Query OK, 1 row affected (0.017 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M05','SISTEMAS DE INF');
Query OK, 1 row affected (0.018 sec)

MariaDB [libreria]> insert into Asignatura(Codigomat,Nombre) values('M09','BASE DE DATOS');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> select * from asignatura;
+-----------+---------------------+
| Codigomat | Nombre              |
+-----------+---------------------+
| M01       | CALCULO             |
| M02       | MATEMATICAS         |
| M03       | ESTRUCTURA DE DATOS |
| M04       | INGL                |
| M08       | DIAGRAAMACION       |
| M06       | CONTABILIDAD        |
| M07       | REDES               |
| M05       | SISTEMAS DE INF     |
| M09       | BASE DE DATOS       |
+-----------+---------------------+
9 rows in set (0.001 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A01,'LUIS JOYANES');
    '> insert into Autor(Codautor,Nombre) values('A01','LUIS JOYANES');
    '> '
    -> insert into Autor(Codautor,Nombre) values('A01','Luis Joyanes');
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 'LUIS JOYANES');
insert into Autor(Codautor,Nombre) values('A01','LUIS JOYANES...' at line 1
MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A01','Luis Joyanes');
Query OK, 1 row affected (0.023 sec)

MariaDB [libreria]> select *from autor;
+----------+--------------+
| Codautor | Nombre       |
+----------+--------------+
| A01      | Luis Joyanes |
+----------+--------------+
1 row in set (0.001 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A02,'Jorge Vasquez Posada');
    '> insert into Autor(Codautor,Nombre) values('A02','Jorge Vasquez Posada');
    '> 
    '> insert into Autor(Codautor,Nombre) values('A02','Jorge Vasquez Posada');
    '> '
    -> .
    -> insert into Autor(Codautor,Nombre) values('A02','Jorge Vasquez Posada');
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 'Jorge Vasquez Posada');
insert into Autor(Codautor,Nombre) values('A02','Jorg...' at line 1
MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A02','Jorge Vasquez Posada');
Query OK, 1 row affected (0.030 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A03','Jhon Soars');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A04','Riaz Khadem');
Query OK, 1 row affected (0.021 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A05','Robert Lorber');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Autor(Codautor,Nombre) values('A06','Mario Dream');
Query OK, 1 row affected (0.003 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.001 sec)

MariaDB [libreria]> insert into Editorial(Codedit,Nombre) values('E01','Oveja Negra');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Editorial(Codedit,Nombre) values('E02','Norma');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Editorial(Codedit,Nombre) values('E03','Mc Graw Hill');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> selec *from editorial;
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 'selec *from editorial' at line 1
MariaDB [libreria]> select *from editorial;
+---------+--------------+
| Codedit | Nombre       |
+---------+--------------+
| E01     | Oveja Negra  |
| E02     | Norma        |
| E03     | Mc Graw Hill |
+---------+--------------+
3 rows in set (0.001 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L02','A01','E01');
Query OK, 1 row affected (0.015 sec)

MariaDB [libreria]> select *from liautedi;
+---------+----------+---------+
| Idlibro | Codautor | Codedit |
+---------+----------+---------+
| L02     | A01      | E01     |
+---------+----------+---------+
1 row in set (0.001 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L02','A05','E03');
Query OK, 1 row affected (0.005 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L06','A02','E02');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L07','A05','E03');
Query OK, 1 row affected (0.003 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L04','A04','E01');
Query OK, 1 row affected (0.004 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L04','A04','E02');
Query OK, 1 row affected (0.141 sec)

MariaDB [libreria]> insert into Liautedi(Idlibro,Codautor,Codedit) values('L04','A04','E03');
Query OK, 1 row affected (0.004 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 *from libro;
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | 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 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.001 sec)

MariaDB [libreria]> select *from editorial;
+---------+--------------+
| Codedit | Nombre       |
+---------+--------------+
| E01     | Oveja Negra  |
| E02     | Norma        |
| E03     | Mc Graw Hill |
+---------+--------------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select *from asignatura;
+-----------+---------------------+
| Codigomat | Nombre              |
+-----------+---------------------+
| M01       | CALCULO             |
| M02       | MATEMATICAS         |
| M03       | ESTRUCTURA DE DATOS |
| M04       | INGL                |
| M08       | DIAGRAAMACION       |
| M06       | CONTABILIDAD        |
| M07       | REDES               |
| M05       | SISTEMAS DE INF     |
| M09       | BASE DE DATOS       |
+-----------+---------------------+
9 rows in set (0.001 sec)

MariaDB [libreria]> select descripcion,precio from libro;
+---------------------+--------+
| descripcion         | precio |
+---------------------+--------+
| CALCULO II          |  55000 |
| BD II               |  65000 |
| ESTRUCTURA DE DATOS |  85000 |
| INGLES              | 105000 |
| ADMON EN UNA PAGINA |   7500 |
| CONTABILIDAD I      |  27500 |
| REDES               |  32500 |
| DIAGRAMACION        |  45000 |
+---------------------+--------+
8 rows in set (0.001 sec)

MariaDB [libreria]> select *from libro where descripicion like '%Redes%';
ERROR 1054 (42S22): Unknown column 'descripicion' in 'where clause'
MariaDB [libreria]> select *from libro where descripcion like '%Redes%';
+---------+-------------+-----------+--------+-----------+
| Idlibro | Descripcion | Nropagina | Precio | Codigomat |
+---------+-------------+-----------+--------+-----------+
| L07     | REDES       |       370 |  32500 | M07       |
+---------+-------------+-----------+--------+-----------+
1 row in set (0.024 sec)

MariaDB [libreria]> select *from libro where descripcion like '%t%';
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | ESTRUCTURA DE DATOS |       180 |  85000 | M03       |
| L06     | CONTABILIDAD I      |       170 |  27500 | M06       |
+---------+---------------------+-----------+--------+-----------+
2 rows in set (0.001 sec)

MariaDB [libreria]> select *from libro where descripcion like '%s';
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | ESTRUCTURA DE DATOS |       180 |  85000 | M03       |
| L04     | INGLES              |       280 | 105000 | M04       |
| L07     | REDES               |       370 |  32500 | M07       |
+---------+---------------------+-----------+--------+-----------+
3 rows in set (0.001 sec)

MariaDB [libreria]> select *from libro where descripcion like 'c%';
+---------+----------------+-----------+--------+-----------+
| Idlibro | Descripcion    | Nropagina | Precio | Codigomat |
+---------+----------------+-----------+--------+-----------+
| L01     | CALCULO II     |       120 |  55000 | M01       |
| L06     | CONTABILIDAD I |       170 |  27500 | M06       |
+---------+----------------+-----------+--------+-----------+
2 rows in set (0.002 sec)

MariaDB [libreria]> select *from libro where Idlibro in('L03','L04','L05');
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| L03     | ESTRUCTURA DE DATOS |       180 |  85000 | M03       |
| L04     | INGLES              |       280 | 105000 | M04       |
| L05     | ADMON EN UNA PAGINA |        70 |   7500 | M05       |
+---------+---------------------+-----------+--------+-----------+
3 rows in set (0.043 sec)

MariaDB [libreria]> select *from libro where Idlibro between 'L02' and 'L06';
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| 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       |
+---------+---------------------+-----------+--------+-----------+
5 rows in set (0.043 sec)

MariaDB [libreria]> select *from libro where nropagina>=100 and precio>=65000;
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| L02     | BD II               |       150 |  65000 | M09       |
| L03     | ESTRUCTURA DE DATOS |       180 |  85000 | M03       |
| L04     | INGLES              |       280 | 105000 | M04       |
+---------+---------------------+-----------+--------+-----------+
3 rows in set (0.036 sec)

MariaDB [libreria]> select *from libro where descripcion= 'REDES';
+---------+-------------+-----------+--------+-----------+
| Idlibro | Descripcion | Nropagina | Precio | Codigomat |
+---------+-------------+-----------+--------+-----------+
| L07     | REDES       |       370 |  32500 | M07       |
+---------+-------------+-----------+--------+-----------+
1 row in set (0.003 sec)

MariaDB [libreria]> select descripcion, nropagina, precio from libro where precio>50000;
+---------------------+-----------+--------+
| descripcion         | nropagina | precio |
+---------------------+-----------+--------+
| CALCULO II          |       120 |  55000 |
| BD II               |       150 |  65000 |
| ESTRUCTURA DE DATOS |       180 |  85000 |
| INGLES              |       280 | 105000 |
+---------------------+-----------+--------+
4 rows in set (0.002 sec)

MariaDB [libreria]> select *from libro where nropagina<160;
+---------+---------------------+-----------+--------+-----------+
| Idlibro | Descripcion         | Nropagina | Precio | Codigomat |
+---------+---------------------+-----------+--------+-----------+
| L01     | CALCULO II          |       120 |  55000 | M01       |
| L02     | BD II               |       150 |  65000 | M09       |
| L05     | ADMON EN UNA PAGINA |        70 |   7500 | M05       |
| L08     | DIAGRAMACION        |        85 |  45000 | M08       |
+---------+---------------------+-----------+--------+-----------+
4 rows in set (0.004 sec)

MariaDB [libreria]> exit