show databases;
tee c:/xampp/clase1mysql.txt;

CREAT 
	-- LE CREAMOS UNA DATABASE CON EL NOMBRE Y LA ASIGNACIÓN (DATABASE)	
	CREATE DATABASE BIBLIOTECA;

	TABLE: 
		SHOW TABLES;
		
	CREATE TABLE LIBRO(
	)

	DESCRIBE TABLE_NAME


MariaDB [(none)]> tee c:/xampp/clase1mysql.txt;
MariaDB [(none)]> CREATE DATABASE BIBLIOTECA;
Query OK, 1 row affected (0.003 sec)

MariaDB [(none)]> show database
    -> show database;
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 'database
show database' at line 1
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]> CREATE TABLE LIBRO
    -> CREATE TABLE LIBRO;
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 'CREATE TABLE LIBRO' at line 2
MariaDB [BIBLIOTECA]> CREATE TABLE LIBRO;
ERROR 1113 (42000): A table must have at least 1 column
MariaDB [BIBLIOTECA]> 
MariaDB [BIBLIOTECA]> CREATE TABLE LIBRO INTO BILIOTECA;
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 'INTO BILIOTECA' at line 1
MariaDB [BIBLIOTECA]> INTO BILIOTECA CREATE TABLE ;
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 'INTO BILIOTECA CREATE TABLE' at line 1
MariaDB [BIBLIOTECA]> INTO BILIOTECA CREATE TABLE LIBRO;
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 'INTO BILIOTECA CREATE TABLE LIBRO' at line 1
MariaDB [BIBLIOTECA]> CREATE TABLE LIBRO{}
    -> 
    -> 
    -> 
    -> 
    -> DSD
    -> 
    -> DSDS
    -> 
    -> 
    -> DSD
    -> SHOW DATABASE
    -> SHOW DATABASE;
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 '{}




DSD

DSDS


DSD
SHOW DATABASE
SHOW DATABASE' at line 1
MariaDB [BIBLIOTECA]> SHOW DATABASE;
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 'DATABASE' at line 1
MariaDB [BIBLIOTECA]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| biblioteca         |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
+--------------------+
6 rows in set (0.001 sec)

MariaDB [BIBLIOTECA]> SHOW TABLE;
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 [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(150)
    -> ;
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 4
MariaDB [BIBLIOTECA]> create table libro
    -> Titulo varchar(60) not null,
    -> create table libro;
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 'varchar(60) not null,
create table libro' at line 2
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.026 sec)

MariaDB [BIBLIOTECA]> SHOW TABLE LIBRO
    -> ;
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 'LIBRO' at line 1
MariaDB [BIBLIOTECA]> SHOW TABLE LIBRO;
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 'LIBRO' at line 1
MariaDB [BIBLIOTECA]> SHOW TABLE LIBRO;
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 'LIBRO' at line 1
MariaDB [BIBLIOTECA]> SHOW TABLES 
    -> ;
+----------------------+
| Tables_in_biblioteca |
+----------------------+
| libro                |
+----------------------+
1 row in set (0.001 sec)

MariaDB [BIBLIOTECA]> SHOW TABLES LIBRO;
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 'LIBRO' at line 1
MariaDB [BIBLIOTECA]> SELECT * FROM LIBRO;
Empty set (0.026 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.014 sec)

MariaDB [BIBLIOTECA]>