MariaDB [(none)]> create database biblioteca; Query OK, 1 row affected (0.001 sec) 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 -> (IdLibro varchar(20) not null primary key, -> Titulo varchar(60) not null, -> NroPaginas int(4) not null, -> Precio Float not null); Query OK, 0 rows affected (0.149 sec) MariaDB [biblioteca]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.001 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 | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Titulo | varchar(60) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.009 sec) MariaDB [biblioteca]> select * from tabla; ERROR 1146 (42S02): Table 'biblioteca.tabla' doesn't exist MariaDB [biblioteca]> select * from libro; Empty set (0.059 sec) MariaDB [biblioteca]> alter table libro drop primary key; Query OK, 0 rows affected (0.543 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | | NULL | | | Titulo | varchar(60) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 4 rows in set (0.009 sec) MariaDB [biblioteca]> alter table libro modify IdLibro varchar(20) not null primary key; Query OK, 0 rows affected (0.369 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | 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]> create table autor -> (CodAutor varchar(5) not null primary key, -> Nombre varchar(20) not null, -> Apellido varchar(20) not null, -> Nacionalidad varchar(20) not null); Query OK, 0 rows affected (0.171 sec) MariaDB [biblioteca]> describe autor; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | CodAutor | varchar(5) | NO | PRI | NULL | | | Nombre | varchar(20) | NO | | NULL | | | Apellido | varchar(20) | NO | | NULL | | | Nacionalidad | varchar(20) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 4 rows in set (0.008 sec) MariaDB [biblioteca]> select * from autor; Empty set (0.000 sec) MariaDB [biblioteca]> create table libro_autor -> (IdLibro varchar(20) not null, -> CodAutor varchar(5) not null, -> foreign key(IdLibro) references libro(IdLibro) on delete cascade on update cascade, -> foreign key(CodAutor) references autor(CodAutor) on delete cascade on update cascade); Query OK, 0 rows affected (0.219 sec) MariaDB [biblioteca]> show tables; +----------------------+ | Tables_in_biblioteca | +----------------------+ | autor | | libro | | libro_autor | +----------------------+ 3 rows in set (0.001 sec) MariaDB [biblioteca]> describe libro_autor -> -> ; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | MUL | NULL | | | CodAutor | varchar(5) | NO | MUL | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.008 sec) MariaDB [biblioteca]> alter table libro add Cantidad int(3) not null; Query OK, 0 rows affected (0.077 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Titulo | varchar(60) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.008 sec) MariaDB [biblioteca]> alter table libro add area varchar(20) not null after Titulo; Query OK, 0 rows affected (0.085 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Titulo | varchar(60) | NO | | NULL | | | area | varchar(20) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 6 rows in set (0.006 sec) MariaDB [biblioteca]> alter table libro add Serial varchar(15) not null first; Query OK, 0 rows affected (0.061 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | Serial | varchar(15) | NO | | NULL | | | IdLibro | varchar(20) | NO | PRI | NULL | | | Titulo | varchar(60) | NO | | NULL | | | area | varchar(20) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 7 rows in set (0.024 sec) MariaDB [biblioteca]> MariaDB [biblioteca]> MariaDB [biblioteca]> alter table libro drop Serial; Query OK, 0 rows affected (0.073 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Titulo | varchar(60) | NO | | NULL | | | area | varchar(20) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 6 rows in set (0.016 sec) MariaDB [biblioteca]> alter table libro change Titulo Nombre varchar(60) not null; Query OK, 0 rows affected (0.060 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [biblioteca]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Nombre | varchar(60) | NO | | NULL | | | area | varchar(20) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 6 rows in set (0.007 sec) MariaDB [biblioteca]> show create table libro; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | libro | CREATE TABLE `libro` ( `IdLibro` varchar(20) NOT NULL, `Nombre` varchar(60) NOT NULL, `area` varchar(20) NOT NULL, `NroPaginas` int(4) NOT NULL, `Precio` float NOT NULL, `Cantidad` int(3) NOT NULL, PRIMARY KEY (`IdLibro`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [biblioteca]> show create table libro_autor; +-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | libro_autor | CREATE TABLE `libro_autor` ( `IdLibro` varchar(20) NOT NULL, `CodAutor` varchar(5) NOT NULL, KEY `IdLibro` (`IdLibro`), KEY `CodAutor` (`CodAutor`), CONSTRAINT `libro_autor_ibfk_1` FOREIGN KEY (`IdLibro`) REFERENCES `libro` (`IdLibro`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `libro_autor_ibfk_2` FOREIGN KEY (`CodAutor`) REFERENCES `autor` (`CodAutor`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 | +-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [biblioteca]> insert into libro(IdLibro,Nombre,Area,NroPaginas,Precio,Cantidad) values('001','A','Informatica',100,4000,50); Query OK, 1 row affected (0.046 sec) MariaDB [biblioteca]> describe libro -> ; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | IdLibro | varchar(20) | NO | PRI | NULL | | | Nombre | varchar(60) | NO | | NULL | | | area | varchar(20) | NO | | NULL | | | NroPaginas | int(4) | NO | | NULL | | | Precio | float | NO | | NULL | | | Cantidad | int(3) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 6 rows in set (0.007 sec) MariaDB [biblioteca]> insert into libro(IdLibro,Nombre,area,NroPaginas,Precio,Cantidad) values('001','A','Informatica',100,4000,50); ERROR 1062 (23000): Duplicate entry '001' for key 'PRIMARY' MariaDB [biblioteca]> insert into libro(IdLibro,Nombre,area,NroPaginas,Precio,Cantidad) values('001','A','Informatica',100,4000,50); ERROR 1062 (23000): Duplicate entry '001' for key 'PRIMARY' MariaDB [biblioteca]> show 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]> select * from libro; +---------+--------+-------------+------------+--------+----------+ | IdLibro | Nombre | area | NroPaginas | Precio | Cantidad | +---------+--------+-------------+------------+--------+----------+ | 001 | A | Informatica | 100 | 4000 | 50 | +---------+--------+-------------+------------+--------+----------+ 1 row in set (0.001 sec) MariaDB [biblioteca]> insert into libro(IdLibro,Nombre,area,NroPaginas,Precio,Cantidad) values('002','B','Base de datos',150,7000,150); Query OK, 1 row affected (0.051 sec) MariaDB [biblioteca]> select * from libro; +---------+--------+---------------+------------+--------+----------+ | IdLibro | Nombre | area | NroPaginas | Precio | Cantidad | +---------+--------+---------------+------------+--------+----------+ | 001 | A | Informatica | 100 | 4000 | 50 | | 002 | B | Base de datos | 150 | 7000 | 150 | +---------+--------+---------------+------------+--------+----------+ 2 rows in set (0.001 sec) MariaDB [biblioteca]> select idlibro,area from libro; +---------+---------------+ | idlibro | area | +---------+---------------+ | 001 | Informatica | | 002 | Base de datos | +---------+---------------+ 2 rows in set (0.001 sec) MariaDB [biblioteca]> mysqldump -B -uroot -p biblioteca>c:/xampp/biblioteca.sql -> , -> exit -> ; 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 'mysqldump -B -uroot -p biblioteca>c:/xampp/biblioteca.sql , exit' at line 1 MariaDB [biblioteca]> exit