MariaDB [(none)]> create database Libreria; ERROR 1007 (HY000): Can't create database 'libreria'; database exists MariaDB [(none)]> create database librerias -> ; Query OK, 1 row affected (0.006 sec) MariaDB [(none)]> use librerias; Database changed MariaDB [librerias]> create table libro(idLibro varchar(10) not null primary key,titulo varchar(50) not null,nropaginas int(3) not null,precio int(8) not null,codigomat varchar(10) not null); Query OK, 0 rows affected (0.029 sec) MariaDB [librerias]> show tables -> ; +---------------------+ | Tables_in_librerias | +---------------------+ | libro | +---------------------+ 1 row in set (0.001 sec) MariaDB [librerias]> create table materia(codigomat varchar(10) not null primary key, nombre varchar(50) not null); Query OK, 0 rows affected (0.037 sec) MariaDB [librerias]> create table autor(codautor varchar(10) not null primary key, nombre varchar(50) not null); Query OK, 0 rows affected (0.032 sec) MariaDB [librerias]> create table editorial(codedit varchar(10) not null primary key, nombre varchar(50) not null); Query OK, 0 rows affected (0.034 sec) MariaDB [librerias]> create table liautedi(idlibro1 varchar(10) not null, codautor1 varchar(10) not null, codedit1 varchar(10) not null, foreign key(idlibro1) references libro(idlibro)on delete cascade on update cascade, foreign key(codautor1) references autor(codautor) on delete cascade on update cascade, foreign key(codedit1) references editorial(codedit) on delete cascade on update cascade); Query OK, 0 rows affected (0.046 sec) MariaDB [librerias]> show tables; +---------------------+ | Tables_in_librerias | +---------------------+ | autor | | editorial | | liautedi | | libro | | materia | +---------------------+ 5 rows in set (0.001 sec) MariaDB [librerias]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | idLibro | varchar(10) | NO | PRI | NULL | | | titulo | varchar(50) | NO | | NULL | | | nropaginas | int(3) | NO | | NULL | | | precio | int(8) | NO | | NULL | | | codigomat | varchar(10) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.044 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L01', 'Calculo II', 120, 55000, 'M01'); Query OK, 1 row affected (0.003 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L02','BD II ', 150, 65000, 'M09'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L03', ' Estructura de datos', 180, 85000, 'M03'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L08', ' Diagramacion ', 85, 45000, 'M08'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L05', 'Admon en una pagina', 70, 7500, 'M05'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L06', 'Contabilidad I', 170, 27500, 'M06'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L07', 'Redes', 370, 32500, 'M07'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L04', 'Ingles', 280, 105000, 'M04'); Query OK, 1 row affected (0.003 sec) MariaDB [librerias]> describe libro; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | idLibro | varchar(10) | NO | PRI | NULL | | | titulo | varchar(50) | NO | | NULL | | | nropaginas | int(3) | NO | | NULL | | | precio | int(8) | NO | | NULL | | | codigomat | varchar(10) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.032 sec) MariaDB [librerias]> select * from libro; +---------+----------------------+------------+--------+-----------+ | idLibro | titulo | 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.000 sec) MariaDB [librerias]> show tables; +---------------------+ | Tables_in_librerias | +---------------------+ | autor | | editorial | | liautedi | | libro | | materia | +---------------------+ 5 rows in set (0.001 sec) MariaDB [librerias]> insert into materia(cądigomat,nombre) values('M01', 'Calculo'); ERROR 1054 (42S22): Unknown column 'cądigomat' in 'field list' MariaDB [librerias]> insert into materia(codigomat,nombre) values('M01', 'Calculo'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M02', 'Matematicas'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M03', 'Estructura de datos'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M04', 'Ingl'); Query OK, 1 row affected (0.003 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M08', 'Diagramacion'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M06', 'Contabilidad'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M07', ' Redes'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M05', ' Sistemas de Inf.'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into materia(codigomat,nombre) values('M09', ' Base de datos'); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(10) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.022 sec) MariaDB [librerias]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingl | | M05 | Sistemas de Inf. | | M06 | Contabilidad | | M07 | Redes | | M08 | Diagramacion | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.000 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A01', ' Luis Joyanes'); Query OK, 1 row affected (0.008 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A02', ' Jorge Vasquez Posada'); Query OK, 1 row affected (0.004 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A03', ' Jhon Soars'); Query OK, 1 row affected (0.007 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A04', ' Riaz Khadem'); Query OK, 1 row affected (0.004 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A05', ' Robert Lorber '); Query OK, 1 row affected (0.004 sec) MariaDB [librerias]> insert into autor(codautor,nombre) values('A06', ' Mario Dream'); Query OK, 1 row affected (0.004 sec) MariaDB [librerias]> 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.000 sec) MariaDB [librerias]> insert into editorial (codedit,nombre) values('E01', ' Oveja Negra '); Query OK, 1 row affected (0.003 sec) MariaDB [librerias]> insert into editorial (codedit,nombre) values('E02', ' Norma '); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into editorial (codedit,nombre) values('E03', ' Mc Graw Hill '); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> select * from editorial; +---------+----------------+ | codedit | nombre | +---------+----------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+----------------+ 3 rows in set (0.000 sec) MariaDB [librerias]> show tables; +---------------------+ | Tables_in_librerias | +---------------------+ | autor | | editorial | | liautedi | | libro | | materia | +---------------------+ 5 rows in set (0.001 sec) MariaDB [librerias]> describe liautedi; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro1 | varchar(10) | NO | MUL | NULL | | | codautor1 | varchar(10) | NO | MUL | NULL | | | codedit1 | varchar(10) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 3 rows in set (0.027 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L02', 'A01', 'E01' ); Query OK, 1 row affected (0.002 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L02', 'A05', 'E03' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L06', 'A02', 'E02' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L07', 'A05', 'E03' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L04', 'A04', 'E01' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L04', 'A04', 'E02' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> insert into liautedi (idlibro1,codautor1,codedit1) values('L04', 'A04', 'E03' ); Query OK, 1 row affected (0.001 sec) MariaDB [librerias]> select * from liautedi; +----------+-----------+----------+ | idlibro1 | codautor1 | codedit1 | +----------+-----------+----------+ | L02 | A01 | E01 | | L02 | A05 | E03 | | L06 | A02 | E02 | | L07 | A05 | E03 | | L04 | A04 | E01 | | L04 | A04 | E02 | | L04 | A04 | E03 | +----------+-----------+----------+ 7 rows in set (0.000 sec) MariaDB [librerias]> alter table libro change titulo descripcion varchar(10) not null; Query OK, 8 rows affected, 4 warnings (0.059 sec) Records: 8 Duplicates: 0 Warnings: 4 MariaDB [librerias]> describe libro; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | idLibro | varchar(10) | NO | PRI | NULL | | | descripcion | varchar(10) | NO | | NULL | | | nropaginas | int(3) | NO | | NULL | | | precio | int(8) | NO | | NULL | | | codigomat | varchar(10) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.020 sec) MariaDB [librerias]> select * from libro; +---------+-------------+------------+--------+-----------+ | idLibro | descripcion | nropaginas | precio | codigomat | +---------+-------------+------------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructur | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L05 | Admon en u | 70 | 7500 | M05 | | L06 | Contabilid | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramac | 85 | 45000 | M08 | +---------+-------------+------------+--------+-----------+ 8 rows in set (0.000 sec) MariaDB [librerias]> 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.000 sec) MariaDB [librerias]> select * from editorial; +---------+----------------+ | codedit | nombre | +---------+----------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+----------------+ 3 rows in set (0.000 sec) MariaDB [librerias]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingl | | M05 | Sistemas de Inf. | | M06 | Contabilidad | | M07 | Redes | | M08 | Diagramacion | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.000 sec) MariaDB [librerias]> select descripcion,precio from libro; +-------------+--------+ | descripcion | precio | +-------------+--------+ | Calculo II | 55000 | | BD II | 65000 | | Estructur | 85000 | | Ingles | 105000 | | Admon en u | 7500 | | Contabilid | 27500 | | Redes | 32500 | | Diagramac | 45000 | +-------------+--------+ 8 rows in set (0.000 sec) MariaDB [librerias]> alter table materia rename to asignatura; Query OK, 0 rows affected (0.007 sec) MariaDB [librerias]> show tables; +---------------------+ | Tables_in_librerias | +---------------------+ | asignatura | | autor | | editorial | | liautedi | | libro | +---------------------+ 5 rows in set (0.001 sec) MariaDB [librerias]> exit