Microsoft Windows [Versión 10.0.19044.2006]
(c) Microsoft Corporation. Todos los derechos reservados.

C:\Users\Harold Martinez>cd/xampp/mysql/bin

C:\xampp\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

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

MariaDB [(none)]> source D:\Descargas\libreria.sql
Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.001 sec)

Database changed
Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 9 rows affected (0.001 sec)
Records: 9  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.010 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 6 rows affected (0.002 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.003 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 3 rows affected (0.001 sec)
Records: 3  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.012 sec)

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 7 rows affected (0.001 sec)
Records: 7  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.006 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.008 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 8 rows affected (0.001 sec)
Records: 8  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

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

MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre, editorial.codedit, editorial.nombre from libro inner join liautedi  on  libro.idlibro=liautedi.idlibro;
ERROR 1054 (42S22): Unknown column 'autor.codautor' in 'field list'
MariaDB [libreria]> select  libro.idlibro,libro.descripcion,liautedi.idlibro from libro left join liautedi  on  libro.idlibro=liautedi.idlibro where liautedi.idlibro is null;
+---------+---------------------+---------+
| idlibro | descripcion         | idlibro |
+---------+---------------------+---------+
| L01     | Calculo II          | NULL    |
| L03     | Estructura de datos | NULL    |
| L05     | Admon en una pagina | NULL    |
| L08     | Diagramacion        | NULL    |
+---------+---------------------+---------+
4 rows in set (0.001 sec)

MariaDB [libreria]> select  libro.idlibro,libro.descripcion,liautedi.idlibro from libro right join liautedi  on  libro.idlibro=liautedi.idlibro;
+---------+----------------+---------+
| idlibro | descripcion    | idlibro |
+---------+----------------+---------+
| L02     | BD II          | L02     |
| L02     | BD II          | L02     |
| L04     | Ingles         | L04     |
| L04     | Ingles         | L04     |
| L04     | Ingles         | L04     |
| L06     | Contabilidad I | L06     |
| L07     | Redes          | L07     |
+---------+----------------+---------+
7 rows in set (0.001 sec)

MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro right join liautedi  on  libro.idlibro=liautedi.idlibro right join autor on liautedi.codautor=autor.codautor;
+---------+----------------+----------+----------------------+
| idlibro | descripcion    | codautor | nombre               |
+---------+----------------+----------+----------------------+
| L02     | BD II          | A01      | Luis Joyanes         |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada |
| NULL    | NULL           | A03      | Jhon Soars           |
| L04     | Ingles         | A04      | Riaz Khadem          |
| L02     | BD II          | A05      | Robert Lorber        |
| L07     | Redes          | A05      | Robert Lorber        |
| NULL    | NULL           | A06      | Mario Dream          |
+---------+----------------+----------+----------------------+
7 rows in set (0.003 sec)

MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro left join liautedi  on  libro.idlibro=liautedi.idlibro left join autor on liautedi.codautor=autor.codautor;
+---------+---------------------+----------+----------------------+
| idlibro | descripcion         | codautor | nombre               |
+---------+---------------------+----------+----------------------+
| L01     | Calculo II          | NULL     | NULL                 |
| L02     | BD II               | A01      | Luis Joyanes         |
| L02     | BD II               | A05      | Robert Lorber        |
| L03     | Estructura de datos | NULL     | NULL                 |
| L04     | Ingles              | A04      | Riaz Khadem          |
| L05     | Admon en una pagina | NULL     | NULL                 |
| L06     | Contabilidad I      | A02      | Jorge Vasquez Posada |
| L07     | Redes               | A05      | Robert Lorber        |
| L08     | Diagramacion        | NULL     | NULL                 |
+---------+---------------------+----------+----------------------+
9 rows in set (0.001 sec)

MariaDB [libreria]> select  libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre from libro inner join liautedi  on  libro.idlibro=liautedi.idlibro inner join editorial on liautedi.codedit=editorial.codedit;
+---------+----------------+---------+--------------+
| idlibro | descripcion    | codedit | nombre       |
+---------+----------------+---------+--------------+
| L02     | BD II          | E01     | Oveja Negra  |
| L04     | Ingles         | E01     | Oveja Negra  |
| L06     | Contabilidad I | E02     | Norma        |
| L04     | Ingles         | E02     | Norma        |
| L02     | BD II          | E03     | Mc Graw Hill |
| L07     | Redes          | E03     | Mc Graw Hill |
| L04     | Ingles         | E03     | Mc Graw Hill |
+---------+----------------+---------+--------------+
7 rows in set (0.003 sec)

MariaDB [libreria]> select  libro.idlibro,libro.descripcion,editorial.codedit,editorial.nombre, autor.codautor, autor.nombre from libro inner join liautedi  on  libro.idlibro=liautedi.idlibro;
ERROR 1054 (42S22): Unknown column 'editorial.codedit' in 'field list'
MariaDB [libreria]> select distinct libro.idlibro,libro.descripcion,autor.codautor,autor.nombre from libro inner join liautedi  on  libro.idlibro=liautedi.idlibro inner join autor on 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.001 sec)

MariaDB [libreria]> select libro.idlibro,libro.descripcion,autor.codautor,autor.nombre, editorial.codedit, editorial.nombre from libro inner join liautedi  on  libro.idlibro=liautedi.idlibro inner join autor on liautedi.codautor=autor.codautor inner join editorial on autor.codautor=liautedi.codautor
    -> ;
+---------+----------------+----------+----------------------+---------+--------------+
| idlibro | descripcion    | codautor | nombre               | codedit | nombre       |
+---------+----------------+----------+----------------------+---------+--------------+
| L02     | BD II          | A01      | Luis Joyanes         | E01     | Oveja Negra  |
| L02     | BD II          | A01      | Luis Joyanes         | E02     | Norma        |
| L02     | BD II          | A01      | Luis Joyanes         | E03     | Mc Graw Hill |
| L02     | BD II          | A05      | Robert Lorber        | E01     | Oveja Negra  |
| L02     | BD II          | A05      | Robert Lorber        | E02     | Norma        |
| L02     | BD II          | A05      | Robert Lorber        | E03     | Mc Graw Hill |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada | E01     | Oveja Negra  |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada | E02     | Norma        |
| L06     | Contabilidad I | A02      | Jorge Vasquez Posada | E03     | Mc Graw Hill |
| L07     | Redes          | A05      | Robert Lorber        | E01     | Oveja Negra  |
| L07     | Redes          | A05      | Robert Lorber        | E02     | Norma        |
| L07     | Redes          | A05      | Robert Lorber        | E03     | Mc Graw Hill |
| L04     | Ingles         | A04      | Riaz Khadem          | E01     | Oveja Negra  |
| L04     | Ingles         | A04      | Riaz Khadem          | E02     | Norma        |
| L04     | Ingles         | A04      | Riaz Khadem          | E03     | Mc Graw Hill |
| L04     | Ingles         | A04      | Riaz Khadem          | E01     | Oveja Negra  |
| L04     | Ingles         | A04      | Riaz Khadem          | E02     | Norma        |
| L04     | Ingles         | A04      | Riaz Khadem          | E03     | Mc Graw Hill |
| L04     | Ingles         | A04      | Riaz Khadem          | E01     | Oveja Negra  |
| L04     | Ingles         | A04      | Riaz Khadem          | E02     | Norma        |
| L04     | Ingles         | A04      | Riaz Khadem          | E03     | Mc Graw Hill |
+---------+----------------+----------+----------------------+---------+--------------+
21 rows in set (0.001 sec)

MariaDB [libreria]>