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

C:\Users\KHANDENY>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 15
Server version: 10.4.20-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)]> use libreria;}
Database changed
    -> ;
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 '}' at line 1
MariaDB [libreria]> alter table asignaturas rename to materias;
Query OK, 0 rows affected (0.315 sec)

MariaDB [libreria]> select * from libros;
+---------+---------------------+------------+--------+-----------+
| idlibro | descripcion         | nropaginas | 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 autores;
ERROR 1146 (42S02): Table 'libreria.autores' doesn't exist
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 materias;
+-----------+-------------------------+
| codigomat | nombre                  |
+-----------+-------------------------+
| M01       | Calculo                 |
| M02       | Matematicas             |
| M03       | Estructura de Datos     |
| M04       | Ingles                  |
| M08       | Diagramacion            |
| M06       | Contabilidad            |
| M07       | Redes                   |
| M05       | Sistemas de Informacion |
| M09       | Base de Datos           |
+-----------+-------------------------+
9 rows in set (0.003 sec)

MariaDB [libreria]> select descripcion,precio from libros;
+---------------------+--------+
| 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 materias rename to asignaturas;
Query OK, 0 rows affected (0.221 sec)

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