MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | nombre_biblioteca | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.009 sec) MariaDB [(none)]> create database Libreria; Query OK, 1 row affected (0.011 sec) MariaDB [(none)]> use Libreria; Database changed MariaDB [Libreria]> create table Materia(codigomat varchar(4) not null primary key, -> nombre varchar(50) not null); Query OK, 0 rows affected (0.077 sec) MariaDB [Libreria]> describe Materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.062 sec) MariaDB [Libreria]> create table Libro(Idlibro varchar(4) not null primary key, -> titulo varchar(50) not null -> nropagina int(5) not null, -> precio int(5) not null, -> codigomat varchar(4) not null, -> foreign key(codigomat) references materia(codigomat) on delete cascade on update cascade); 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 'int(5) not null, precio int(5) not null, codigomat varchar(4) not null, forei...' at line 3 MariaDB [Libreria]> create table Libro(Idlibro varchar(4) not null primary key, -> titulo varchar(50) not null, -> nropagina int(5) not null, -> precio int(5) not null, -> codigomat varchar(4) not null, -> foreign key(codigomat) references materia(codigomat) on delete cascade on update cascade); Query OK, 0 rows affected (0.125 sec) MariaDB [Libreria]> describe Libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | Idlibro | varchar(4) | NO | PRI | NULL | | | titulo | varchar(50) | NO | | NULL | | | nropagina | int(5) | NO | | NULL | | | precio | int(5) | NO | | NULL | | | codigomat | varchar(4) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.057 sec) MariaDB [Libreria]> create table Autor(codautor varchar(4) not null primary key, -> nombre varchar(4) not null); Query OK, 0 rows affected (0.070 sec) MariaDB [Libreria]> describe Autor; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | codautor | varchar(4) | NO | PRI | NULL | | | nombre | varchar(4) | NO | | NULL | | +----------+------------+------+-----+---------+-------+ 2 rows in set (0.058 sec) MariaDB [Libreria]> drop table Autor; Query OK, 0 rows affected (0.034 sec) MariaDB [Libreria]> create table autor(codautor varchar(4) not null primary key, -> nombre varchar(50) not null); Query OK, 0 rows affected (0.066 sec) MariaDB [Libreria]> describe Autor; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | codautor | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.050 sec) MariaDB [Libreria]> create table Editorial(codedit varchar(4) not null primary key, -> nombre varchar(50) not null); Query OK, 0 rows affected (0.069 sec) MariaDB [Libreria]> create table Liautedi(idlibro varchar(4) not null, -> codautor varchar(4) not null, -> codedit varchar(4) 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.126 sec) MariaDB [Libreria]> describe Liautedi; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | idlibro | varchar(4) | NO | MUL | NULL | | | codautor | varchar(4) | NO | MUL | NULL | | | codedit | varchar(4) | NO | MUL | NULL | | +----------+------------+------+-----+---------+-------+ 3 rows in set (0.054 sec) MariaDB [Libreria]> insert into Materia(codigomat, nombre) values('M01','Calculo'); Query OK, 1 row affected (0.017 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M02','Matematicas'); Query OK, 1 row affected (0.016 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M03','Estructura de datos'); Query OK, 1 row affected (0.006 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M04','Ingles'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M08','Diagramacion'); Query OK, 1 row affected (0.014 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M06','Contabilidad'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M07','Redes'); Query OK, 1 row affected (0.016 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M05','Sistemas de inf'); Query OK, 1 row affected (0.016 sec) MariaDB [Libreria]> insert into materia(codigomat, nombre) values('M09','Base de datos'); Query OK, 1 row affected (0.005 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A01','Luis Joyanes'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A02','Jorge Vasquez Posada'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A03','Jhon Soars'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A04','Riaz Khadem'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A05','Robert Lorber'); Query OK, 1 row affected (0.016 sec) MariaDB [Libreria]> insert into autor(codautor, nombre) values('A06','Mario Dream'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into editorial(codedit, nombre) values('E01','Oveja Negra'); Query OK, 1 row affected (0.021 sec) MariaDB [Libreria]> insert into editorial(codedit, nombre) values('E02','Norma'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into editorial(codedit, nombre) values('E03','Mc Graw Hill'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L01','Calculo II', 120, 55000,'M01'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L02','BD II', 150, 65000,'M09'); Query OK, 1 row affected (0.018 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.016 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L08','Diagramacion', 85,45000,'M08'); Query OK, 1 row affected (0.006 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.015 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L06','Contabilidad I', 170,27500,'M06'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L07','Redes', 370,32500,'M07'); Query OK, 1 row affected (0.018 sec) MariaDB [Libreria]> insert into libro(idlibro, titulo, nropagina, precio, codigomat) values('L04','Ingles', 280, 105000,'M04'); Query OK, 1 row affected (0.014 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L02','A01','E01'); Query OK, 1 row affected (0.016 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L02','A05','E03'); Query OK, 1 row affected (0.006 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L06','A02','E02'); Query OK, 1 row affected (0.017 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L07','A05','E03'); Query OK, 1 row affected (0.005 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E01'); Query OK, 1 row affected (0.015 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E02'); Query OK, 1 row affected (0.014 sec) MariaDB [Libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E03'); Query OK, 1 row affected (0.014 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 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 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 * 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.001 sec) MariaDB [Libreria]> select descripcion, precio from libro; ERROR 1054 (42S22): Unknown column 'descripcion' in 'field list' MariaDB [Libreria]> alter table libro change Titulo descripcion varchar(50) not null; Query OK, 0 rows affected (0.033 sec) Records: 0 Duplicates: 0 Warnings: 0 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]> alter table Materia rename to Asignatura; Query OK, 0 rows affected (0.054 sec) MariaDB [Libreria]> describe Asignatura; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.061 sec) MariaDB [Libreria]> select * from libro where descripcion like '%redes%'; +---------+-------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+-------------+-----------+--------+-----------+ 1 row in set (0.001 sec) MariaDB [Libreria]> exit 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.206 sec) MariaDB [libreria]> select * from libro where idlibro='L01'; +---------+-------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | +---------+-------------+-----------+--------+-----------+ 1 row 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.002 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 descripcion='redes'; +---------+-------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+-------------+-----------+--------+-----------+ 1 row in set (0.001 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.002 sec) MariaDB [libreria]> select * from libro where idlibro='L01' or idlibro='L02' or idlibro='L03'; +---------+---------------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de Datos | 180 | 85000 | M03 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.002 sec) MariaDB [libreria]> select * from libro where idlibro>='L01' and idlibro<='L05'; +---------+---------------------+-----------+--------+-----------+ | 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 | +---------+---------------------+-----------+--------+-----------+ 5 rows in set (0.002 sec) MariaDB [libreria]> select * from libro where idlibro in('L01','L02','L03'); +---------+---------------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de Datos | 180 | 85000 | M03 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.001 sec) MariaDB [libreria]> select * from libro where idlibro between 'L01' and 'L06'; +---------+---------------------+-----------+--------+-----------+ | 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 | +---------+---------------------+-----------+--------+-----------+ 6 rows in set (0.002 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 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 '%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 '%redes%'; +---------+-------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+-------------+-----------+--------+-----------+ 1 row in set (0.001 sec) MariaDB [libreria]> select * from libro where descripcion like '%II%'; +---------+-------------+-----------+--------+-----------+ | Idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | +---------+-------------+-----------+--------+-----------+ 2 rows in set (0.001 sec) MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro,autor,liautedi where libro.idlibro=liautedi.idlibro and liautedi.codautor=autor.codautor; +---------+----------------+----------+----------------------+ | idlibro | descripcion | codautor | nombre | +---------+----------------+----------+----------------------+ | L02 | BD II | A01 | Luis Joyanes | | L02 | BD II | A05 | Robert Lorber | | L06 | Contabilidad I | A02 | Jorge Vasquez Posada | | L07 | Redes | A05 | Robert Lorber | | L04 | Ingles | A04 | Riaz Khadem | | L04 | Ingles | A04 | Riaz Khadem | | L04 | Ingles | A04 | Riaz Khadem | +---------+----------------+----------+----------------------+ 7 rows in set (0.072 sec) MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro,autor,liautedi where libro.idlibro=liautedi.idlibro and liautedi.codautor=autor.codautor; +---------+----------------+----------+----------------------+ | idlibro | descripcion | codautor | nombre | +---------+----------------+----------+----------------------+ | L02 | BD II | A01 | Luis Joyanes | | L02 | BD II | A05 | Robert Lorber | | L06 | Contabilidad I | A02 | Jorge Vasquez Posada | | L07 | Redes | A05 | Robert Lorber | | L04 | Ingles | A04 | Riaz Khadem | +---------+----------------+----------+----------------------+ 5 rows in set (0.002 sec) MariaDB [libreria]> select libro.descripcion,autor.nombre from libro,autor,liautedi where libro.descripcion='Estructura de datos' and libro.idlibro=liautedi.idlibro and liautedi.codautor=autor.codautor; Empty set (0.002 sec) MariaDB [libreria]> exit