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

C:\Users\luis3>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 11
Server version: 10.4.27-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)]> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.012 sec)

MariaDB [(none)]> use biblioteca
Database changed
MariaDB [biblioteca]> show tables;
+----------------------+
| Tables_in_biblioteca |
+----------------------+
| autor                |
| autor_editorial      |
| editorial            |
| libro                |
| libro_autor          |
| prestamo             |
| usuario              |
+----------------------+
7 rows in set (0.000 sec)

MariaDB [biblioteca]> describe autor
    -> ;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| Idautor      | varchar(10) | NO   | PRI | NULL    |       |
| Nombre       | varchar(50) | NO   |     | NULL    |       |
| Nacionalidad | varchar(30) | NO   |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.008 sec)

MariaDB [biblioteca]> describe autor_editorial;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Idautor          | varchar(10) | NO   | MUL | NULL    |       |
| Codigo_editorial | varchar(10) | NO   | MUL | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
2 rows in set (0.007 sec)

MariaDB [biblioteca]> describe editorial;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Codigo_editorial | varchar(10) | NO   | PRI | NULL    |       |
| Nombre           | varchar(30) | NO   |     | NULL    |       |
| Contacto         | int(11)     | NO   |     | NULL    |       |
| Direccion        | varchar(30) | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
4 rows in set (0.006 sec)

MariaDB [biblioteca]> describe prestamo
    -> ;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Id_consecutivo   | int(7)      | NO   | PRI | NULL    |       |
| Idlibro          | varchar(10) | NO   | MUL | NULL    |       |
| Cedula           | int(12)     | NO   | MUL | NULL    |       |
| Fecha_prestamo   | varchar(20) | NO   |     | NULL    |       |
| Fecha_devolucion | varchar(20) | NO   |     | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
5 rows in set (0.006 sec)

MariaDB [biblioteca]> describe usuario;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| Cedula     | int(12)     | NO   | PRI | NULL    |       |
| Nombre     | varchar(30) | NO   |     | NULL    |       |
| Telefono   | int(10)     | NO   |     | NULL    |       |
| Direccion  | varchar(30) | NO   |     | NULL    |       |
| Referencia | int(12)     | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.007 sec)

MariaDB [biblioteca]> describe autor_editorial;
+------------------+-------------+------+-----+---------+-------+
| Field            | Type        | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| Idautor          | varchar(10) | NO   | MUL | NULL    |       |
| Codigo_editorial | varchar(10) | NO   | MUL | NULL    |       |
+------------------+-------------+------+-----+---------+-------+
2 rows in set (0.007 sec)

MariaDB [biblioteca]> describe libro;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| Idlibro    | varchar(10) | NO   | PRI | NULL    |       |
| Titulo     | varchar(60) | NO   |     | NULL    |       |
| Nropaginas | int(4)      | NO   |     | NULL    |       |
| Precio     | float       | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.006 sec)

MariaDB [biblioteca]> describe libro_autor;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| Idlibro | varchar(10) | NO   | MUL | NULL    |       |
| Idautor | varchar(10) | NO   | MUL | NULL    |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.008 sec)

MariaDB [biblioteca]> exit
Bye

C:\xampp\mysql\bin>mysqldump -B -uroot -p biblioteca>c:/xampp/Bd_Biblioteca.sql
Enter password:

C:\xampp\mysql\bin>