MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
5 rows in set (0.001 sec)

MariaDB [(none)]> create database biblioteca;
Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]> show databases
    -> 6
    -> 
    -> 
    -> 
    -> c
    -> ;
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 '6



c' at line 2
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.001 sec)

MariaDB [(none)]> use biblioteca;
Database changed
MariaDB [biblioteca]> show tables;
Empty set (0.001 sec)

MariaDB [biblioteca]> create table libro
    -> (Codigo_L varchar(20) not null primary key,
    -> Titulo varchar(60) not null,
    -> Isbn varchar(15) not null,
    -> Editorial varchar(50) not null,
    -> Paginas int not null);
Query OK, 0 rows affected (0.015 sec)

MariaDB [biblioteca]> show tables;
+----------------------+
| Tables_in_biblioteca |
+----------------------+
| libro                |
+----------------------+
1 row in set (0.001 sec)

MariaDB [biblioteca]> describe libro;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Codigo_L  | varchar(20) | NO   | PRI | NULL    |       |
| Titulo    | varchar(60) | NO   |     | NULL    |       |
| Isbn      | varchar(15) | NO   |     | NULL    |       |
| Editorial | varchar(50) | NO   |     | NULL    |       |
| Paginas   | int(11)     | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.013 sec)

MariaDB [biblioteca]> tee c:/xampp/clase1mysql2.txt