MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | colegio | | comercial | | facturacion | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 8 rows in set (0.13 sec) MariaDB [(none)]> create database libreria; Query OK, 1 row affected (0.14 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | colegio | | comercial | | facturacion | | information_schema | | libreria | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 9 rows in set (0.01 sec) MariaDB [(none)]> use libreria; Database changed MariaDB [libreria]> create table materia -> (Codmateria varchar(7) not null primary key, -> nombre varchar(7) not null); Query OK, 0 rows affected (0.48 sec) MariaDB [libreria]> create table libro -> (Idlibro varchar(7) not null primary key, -> titulo varchar(7) not null, -> Nropaginas int(7) not null, -> precio int(7) not null, -> Codmateria varchar(7) not null); Query OK, 0 rows affected (0.31 sec) MariaDB [libreria]> create table autor -> (Codautor varchar(7) not null primary key, -> nombre varchar(7) not null); Query OK, 0 rows affected (0.37 sec) MariaDB [libreria]> create table editorial -> (Codeditorial varchar(7) not null primary key, -> nombre varchar(7) not null); Query OK, 0 rows affected (0.31 sec) MariaDB [libreria]> create table liautedi -> (Idlibro varchar(7) not null, -> Codautor varchar(7) not null, -> Codeditorial varchar(7) 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, -> foreign key(Codeditorial) references editorial(Codeditorial) on delete cascade on update cascade); Query OK, 0 rows affected (0.52 sec) MariaDB [libreria]> show tables; +--------------------+ | Tables_in_libreria | +--------------------+ | autor | | editorial | | liautedi | | libro | | materia | +--------------------+ 5 rows in set (0.03 sec) MariaDB [libreria]> describe materia; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Codmateria | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 2 rows in set (0.08 sec) MariaDB [libreria]> describe libro; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | PRI | NULL | | | titulo | varchar(7) | NO | | NULL | | | Nropaginas | int(7) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | Codmateria | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [libreria]> describe autor; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | Codautor | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +----------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> describe editorial; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | Codeditorial | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +--------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> describe liautedi; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | MUL | NULL | | | Codautor | varchar(7) | NO | MUL | NULL | | | Codeditorial | varchar(7) | NO | MUL | NULL | | +--------------+------------+------+-----+---------+-------+ 3 rows in set (0.08 sec) MariaDB [libreria]> exit MariaDB [(none)]> source C:\xampp\libreria.sql Query OK, 0 rows affected (0.08 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.02 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Database changed Query OK, 0 rows affected (0.45 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.04 sec) Query OK, 0 rows affected (0.58 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.28 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.41 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.30 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.46 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.24 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.43 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.32 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.48 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [libreria]> describe materia; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Codmateria | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 2 rows in set (0.22 sec) MariaDB [libreria]> describe libro; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | PRI | NULL | | | titulo | varchar(7) | NO | | NULL | | | Nropaginas | int(7) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | Codmateria | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [libreria]> describe liautedi; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | MUL | NULL | | | Codautor | varchar(7) | NO | MUL | NULL | | | Codeditorial | varchar(7) | NO | MUL | NULL | | +--------------+------------+------+-----+---------+-------+ 3 rows in set (0.04 sec) MariaDB [libreria]> describe autor; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | Codautor | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +----------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> describe editorial; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | Codeditorial | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +--------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> alter table materia rename to asignatura; Query OK, 0 rows affected (0.32 sec) MariaDB [libreria]> describe asignatura; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Codmateria | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> alter table asignatura drop primary key; Query OK, 0 rows affected (0.91 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe asignatura; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Codmateria | varchar(7) | NO | | NULL | | | nombre | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> alter table asignatura change Codmateria Codasignatura varchar(7) not null; Query OK, 0 rows affected (0.12 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe asignatura; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Codasignatura | varchar(7) | NO | | NULL | | | nombre | varchar(7) | NO | | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> alter table asignatura modify Codasignatura varchar(7) not null primary key; Query OK, 0 rows affected (0.66 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe asignatura; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Codasignatura | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> MariaDB [(none)]> source C:\xampp\libreria.sql Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Database changed Query OK, 0 rows affected (0.20 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.28 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.18 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.34 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.21 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.37 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.23 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.36 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.28 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [libreria]> describe asignatura; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Codasignatura | varchar(7) | NO | PRI | NULL | | | nombre | varchar(7) | NO | | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.04 sec) MariaDB [libreria]> select * from asignatura; Empty set (0.00 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M19','Matematicas'); Query OK, 1 row affected, 1 warning (0.07 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M20','Bases de datos'); Query OK, 1 row affected, 1 warning (0.09 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M21','Estructura de datos'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M22','ingles'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M23','Redes'); Query OK, 1 row affected (0.17 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M24','Contabilidad'); Query OK, 1 row affected, 1 warning (0.09 sec) MariaDB [libreria]> insert into asignatura(Codasignatura,nombre) values('M25','Programacion2'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> select * from asignatura; +---------------+---------+ | Codasignatura | nombre | +---------------+---------+ | M19 | Matemat | | M20 | Bases d | | M21 | Estruct | | M22 | ingles | | M23 | Redes | | M24 | Contabi | | M25 | Program | +---------------+---------+ 7 rows in set (0.00 sec) MariaDB [libreria]> describe libro; +------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | PRI | NULL | | | titulo | varchar(7) | NO | | NULL | | | Nropaginas | int(7) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | Codmateria | varchar(7) | NO | | NULL | | +------------+------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [libreria]> alter table libro change Codmateria Codasignatura varchar(7) not null; Query OK, 0 rows affected (0.19 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe libro; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | PRI | NULL | | | titulo | varchar(7) | NO | | NULL | | | Nropaginas | int(7) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | Codasignatura | varchar(7) | NO | | NULL | | +---------------+------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [libreria]> alter table libro change titulo descripcion varchar(7) not null; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe libro; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Idlibro | varchar(7) | NO | PRI | NULL | | | descripcion | varchar(7) | NO | | NULL | | | Nropaginas | int(7) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | Codasignatura | varchar(7) | NO | | NULL | | +---------------+------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) MariaDB [libreria]> select * from libro; Empty set (0.00 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L01','A',100,5000,'M19'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L02','B',220,6500,'M29'); Query OK, 1 row affected (0.18 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L03','C',150,7800,'M21'); Query OK, 1 row affected (0.07 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L04','D',90,10000,'M22'); Query OK, 1 row affected (0.11 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L05','E',130,12500,'M23'); Query OK, 1 row affected (0.10 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L06','F',250,9700,'M24'); Query OK, 1 row affected (0.19 sec) MariaDB [libreria]> insert into libro(Idlibro,descripcion,Nropaginas,precio,Codasignatura) values('L07','G',300,18600,'M25'); Query OK, 1 row affected (0.10 sec) MariaDB [libreria]> select * from libro; +---------+-------------+------------+--------+---------------+ | Idlibro | descripcion | Nropaginas | precio | Codasignatura | +---------+-------------+------------+--------+---------------+ | L01 | A | 100 | 5000 | M19 | | L02 | B | 220 | 6500 | M20 | | L03 | C | 150 | 7800 | M21 | | L04 | D | 90 | 10000 | M22 | | L05 | E | 130 | 12500 | M23 | | L06 | F | 250 | 9700 | M24 | | L07 | G | 300 | 18600 | M25 | +---------+-------------+------------+--------+---------------+ 7 rows in set (0.00 sec) MariaDB [libreria]> select * from autor; Empty set (0.01 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A19','Jorge Vasquez'); Query OK, 1 row affected, 1 warning (0.05 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A20','Jhon Soars'); Query OK, 1 row affected, 1 warning (0.07 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A21','Riaz Khadem'); Query OK, 1 row affected, 1 warning (0.07 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A22','Robert Lorber'); Query OK, 1 row affected, 1 warning (0.09 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A23','Mario Dream'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A24','Luis Joyanes'); Query OK, 1 row affected, 1 warning (0.10 sec) MariaDB [libreria]> insert into autor(Codautor,nombre) values('A25','Marcos Lopez'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> select * from autor; +----------+---------+ | Codautor | nombre | +----------+---------+ | A19 | Jorge V | | A20 | Jhon So | | A21 | Riaz Kh | | A22 | Robert | | A23 | Mario D | | A24 | Luis Jo | | A25 | Marcos | +----------+---------+ 7 rows in set (0.00 sec) MariaDB [libreria]> select * from editorial; Empty set (0.01 sec) MariaDB [libreria]> insert into editorial(Codeditorial,nombre) values('E002','Oveja negra'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> insert into editorial(Codeditorial,nombre) values('E003','Norma'); Query OK, 1 row affected (0.11 sec) MariaDB [libreria]> insert into editorial(Codeditorial,nombre) values('E004','McGraw Hill'); Query OK, 1 row affected, 1 warning (0.12 sec) MariaDB [libreria]> insert into editorial(Codeditorial,nombre) values('E005','Lemoine Editores'); Query OK, 1 row affected, 1 warning (0.12 sec) MariaDB [libreria]> insert into editorial(Codeditorial,nombre) values('E006','Pack Publishing'); Query OK, 1 row affected, 1 warning (0.06 sec) MariaDB [libreria]> select * from editorial; +--------------+---------+ | Codeditorial | nombre | +--------------+---------+ | E002 | Oveja n | | E003 | Norma | | E004 | McGraw | | E005 | Lemoine | | E006 | Pack Pu | +--------------+---------+ 5 rows in set (0.00 sec) MariaDB [libreria]> select * from liautedi; Empty set (0.00 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L01','A19','E002'); Query OK, 1 row affected (0.17 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L02','A20','E003'); Query OK, 1 row affected (0.15 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L03','A21','E004'); Query OK, 1 row affected (0.11 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L04','A22','E004'); Query OK, 1 row affected (0.12 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L05','A23','E005'); Query OK, 1 row affected (0.24 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L06','A24','E006'); Query OK, 1 row affected (0.12 sec) MariaDB [libreria]> insert into liautedi(Idlibro,Codautor,Codeditorial) values('L07','A25','E006'); Query OK, 1 row affected (0.06 sec) MariaDB [libreria]> select * from liautedi; +---------+----------+--------------+ | Idlibro | Codautor | Codeditorial | +---------+----------+--------------+ | L01 | A19 | E002 | | L02 | A20 | E003 | | L03 | A21 | E004 | | L04 | A22 | E004 | | L05 | A23 | E005 | | L06 | A24 | E006 | | L07 | A25 | E006 | +---------+----------+--------------+ 7 rows in set (0.00 sec) MariaDB [libreria]> select * from libro; +---------+-------------+------------+--------+---------------+ | Idlibro | descripcion | Nropaginas | precio | Codasignatura | +---------+-------------+------------+--------+---------------+ | L01 | A | 100 | 5000 | M19 | | L02 | B | 220 | 6500 | M20 | | L03 | C | 150 | 7800 | M21 | | L04 | D | 90 | 10000 | M22 | | L05 | E | 130 | 12500 | M23 | | L06 | F | 250 | 9700 | M24 | | L07 | G | 300 | 18600 | M25 | +---------+-------------+------------+--------+---------------+ 7 rows in set (0.01 sec) MariaDB [libreria]> select descripcion,precio from libro; +-------------+--------+ | descripcion | precio | +-------------+--------+ | A | 5000 | | B | 6500 | | C | 7800 | | D | 10000 | | E | 12500 | | F | 9700 | | G | 18600 | +-------------+--------+ 7 rows in set (0.00 sec) MariaDB [libreria]> exit