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.001 sec) MariaDB [libreria]> select descripcion, nropagina, precio from libro where precio>5000; +---------------------+-----------+--------+ | descripcion | 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.000 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.000 sec) MariaDB [libreria]> select * from libro where descripcion='BD II'; +---------+-------------+-----------+--------+-----------+ | idlibro | descripcion | nropagina | precio | codigomat | +---------+-------------+-----------+--------+-----------+ | L02 | BD II | 150 | 65000 | M09 | +---------+-------------+-----------+--------+-----------+ 1 row in set (0.000 sec) MariaDB [libreria]> select * from libro where nropagina>=100 and precio>=10000; +---------+---------------------+-----------+--------+-----------+ | 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 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | +---------+---------------------+-----------+--------+-----------+ 6 rows in set (0.000 sec) MariaDB [libreria]> describe libro; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idlibro | varchar(10) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | nropagina | int(8) | NO | | NULL | | | precio | int(8) | NO | | NULL | | | codigomat | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.006 sec) MariaDB [libreria]> select * from libro where nropagina>=100 and precio>=10000; +---------+---------------------+-----------+--------+-----------+ | 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 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | +---------+---------------------+-----------+--------+-----------+ 6 rows in set (0.000 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.000 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.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.000 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.000 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.000 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.000 sec) MariaDB [libreria]> select * from libro where descripcion like '%datos%'; +---------+---------------------+-----------+--------+-----------+ | idlibro | descripcion | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L03 | Estructura de datos | 180 | 85000 | M03 | +---------+---------------------+-----------+--------+-----------+ 1 row in set (0.000 sec) MariaDB [libreria]> describe editorial; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | codedit | varchar(10) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [libreria]> 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.000 sec) MariaDB [libreria]> 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.000 sec) MariaDB [libreria]> 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.000 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.000 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.000 sec) MariaDB [libreria]> MariaDB [libreria]> exit