MariaDB [(none)]> create database libreria; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> use Biblioteca; ERROR 1049 (42000): Unknown database 'biblioteca' MariaDB [(none)]> create table libro(Idlibro varchar(20) not null primary key, -> titulo varchar(60) not null, -> nropaginas int(4) not null, -> Precio Float not null, -> codigomat varchar(20) not null); ERROR 1046 (3D000): No database selected MariaDB [(none)]> use libreria; Database changed MariaDB [libreria]> create table libro(Idlibro varchar(20) not null primary key, -> titulo varchar(60) not null, -> nropaginas int(4) not null, -> Precio Float not null, -> codigomat varchar(20) not null); Query OK, 0 rows affected (0.013 sec) MariaDB [libreria]> show tables -> ; +--------------------+ | Tables_in_libreria | +--------------------+ | libro | +--------------------+ 1 row in set (0.001 sec) MariaDB [libreria]> 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 | | | codigomat | varchar(20) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.006 sec) MariaDB [libreria]> create table materia(codigomat varchar(20) not null primar key, -> nombre varchar(60) not null); 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 'key, nombre varchar(60) not null)' at line 1 MariaDB [libreria]> create table materia(codigomat varchar(20) not null primary key, -> nombre varchar(60) not null); Query OK, 0 rows affected (0.014 sec) MariaDB [libreria]> materia -> ; 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 'materia' at line 1 MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.006 sec) MariaDB [libreria]> create table autor(codautor(20) not null primary key, -> nombre varchar(60) not null); 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 '(20) not null primary key, nombre varchar(60) not null)' at line 1 MariaDB [libreria]> create table autor(codautor varchar(20) not null primary key, -> nombre varchar(60) not null); Query OK, 0 rows affected (0.013 sec) MariaDB [libreria]> describe autor; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | codautor | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.006 sec) MariaDB [libreria]> create table editorial(codedit varchar(20) not null primary key, -> nombre varchar(60) not null); Query OK, 0 rows affected (0.014 sec) MariaDB [libreria]> describe editorial; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | codedit | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [libreria]> create table liautedi(idlibro varchar(20) not null primary key, -> codautor varchar(20) not null, -> codedit varchar(20) not null); Query OK, 0 rows affected (0.014 sec) MariaDB [libreria]> describe lialtedi; ERROR 1146 (42S02): Table 'libreria.lialtedi' doesn't exist MariaDB [libreria]> 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(codedit) references editorial(codedit) on delete cascade on uptade cascade); 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 'foreign key(idlibro) references libro(idlibro) on delete cascade on update ca...' at line 1 MariaDB [libreria]> create table liautedi(idlibro varchar(20) not null, -> codautor varchar(20) not null, -> codedit varchar(20) not null, -> foreign key(idlibro) referenceslibro(idlibro) on delete cascade on update cascade, -> foreign key(codautor) referenceslibro(codautor) on delete cascade on update cascade, -> foreign key(codedit) referenceslibro(codedit) on delete cascade on update cascade); 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 'referenceslibro(idlibro) on delete cascade on update cascade, foreign key(cod...' at line 4 MariaDB [libreria]> 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(codedit) references editorial(codedit) on delete cascade on update cascade); 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 'foreign key(idlibro) references libro(idlibro) on delete cascade on update ca...' at line 1 MariaDB [libreria]> create table liautedi(idlibro varchar(20) not null, -> codautor varchar(20) not null, -> codedit varchar(20) 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(codedit) references editorial(codedit) on delete cascade on update cascade); ERROR 1050 (42S01): Table 'liautedi' already exists MariaDB [libreria]> drop table liautedi; Query OK, 0 rows affected (0.029 sec) MariaDB [libreria]> create table liautedi(idlibro varchar(20) not null, -> codautor varchar(20) not null, -> codedit varchar(20) 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(codedit) references editorial(codedit) on delete cascade on update cascade); Query OK, 0 rows affected (0.016 sec) MariaDB [libreria]> 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 | | | codigomat | varchar(20) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.005 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L01','Calculo II', 120, 55000,'M01'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L02','BD II', 150, 65000,'M09'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L03','Estructura de Datos', 180, 85000,'M03'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L08','Diagramacion', 280,10500,'M08'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L05','Admon en una Pagina', 70, 7500,'M05'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L06','Contabilidad I', 170,27500,'M06'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L07','Redes', 370,32500,'M07'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into libro(idlibro, titulo, nropaginas, precio, codigomat) values('L04','Ingles', 85, 45000,'M04'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> 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 | | | codigomat | varchar(20) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.005 sec) MariaDB [libreria]> 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 | | L08 | Diagramacion | 280 | 10500 | M08 | | L05 | Admon en una Pagina | 70 | 7500 | M05 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | |L04 | Ingles | 85 | 45000 | M04 | +---------+---------------------+------------+--------+-----------+ 8 rows in set (0.000 sec) MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M01','Calculo'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M02','Matematicas'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M03','Estructura de datos'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M04','Ingles'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M05','Diagramacion'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M06','Contabilidad'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M07','Redes'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M08','Sistemas de inf'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into materia(codigomat, nombre) values('M09','Base de datos'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(20) | NO | PRI | NULL | | | nombre | varchar(60) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.005 sec) MariaDB [libreria]> select from * materia; 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 'from * materia' at line 1 MariaDB [libreria]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingles | | M05 | Diagramacion | | M06 | Contabilidad | | M07 | Redes | | M08 | Sistemas de inf | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.000 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A01','Luis Joyanes'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A02','Jorge Vasquez Posada'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A03','Jhon Soars'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A04','Riaz Khedem'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A05','Robert Lorber'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into autor(codautor, nombre) values('A06','Mario Dream'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into editorial(codedit, nombre) values('E01','Oveja Negra'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into editorial(codedit, nombre) values('E02','Norma'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> insert into editorial(codedit, nombre) values('E03','Mc Graw Hill'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> select * from autor; +----------+----------------------+ | codautor | nombre | +----------+----------------------+ | A01 | Luis Joyanes | | A02 | Jorge Vasquez Posada | | A03 | Jhon Soars | | A04 | Riaz Khedem | | A05 | Robert Lorber | | A06 | Mario Dream | +----------+----------------------+ 6 rows in set (0.000 sec) MariaDB [libreria]> select * from editorial; +---------+--------------+ | codedit | nombre | +---------+--------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+--------------+ 3 rows in set (0.000 sec) MariaDB [libreria]> 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 | 85 | 45000 | M04 | | L05 | Admon en una Pagina | 70 | 7500 | M05 | | L06 | Contabilidad I | 170 | 27500 | M06 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramacion | 280 | 10500 | M08 | +---------+---------------------+------------+--------+-----------+ 8 rows in set (0.000 sec) MariaDB [libreria]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingles | | M05 | Diagramacion | | M06 | Contabilidad | | M07 | Redes | | M08 | Sistemas de inf | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.000 sec) MariaDB [libreria]> select * from autor; +----------+----------------------+ | codautor | nombre | +----------+----------------------+ | A01 | Luis Joyanes | | A02 | Jorge Vasquez Posada | | A03 | Jhon Soars | | A04 | Riaz Khedem | | A05 | Robert Lorber | | A06 | Mario Dream | +----------+----------------------+ 6 rows in set (0.000 sec) MariaDB [libreria]> select * from editorial; +---------+--------------+ | codedit | nombre | +---------+--------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+--------------+ 3 rows in set (0.000 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L02','A01','E01'); Query OK, 1 row affected (0.003 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L02','A05','E03'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L06','A02','E02'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L07','A05','E03'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E01'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E02'); Query OK, 1 row affected (0.001 sec) MariaDB [libreria]> insert into liautedi(idlibro, codautor, codedit) values('L04','A04','E03'); Query OK, 1 row affected (0.002 sec) MariaDB [libreria]> select * from liautedi; +---------+----------+---------+ | idlibro | codautor | codedit | +---------+----------+---------+ | L02 | A01 | E01 | | L02 | A05 | E03 | | L06 | A02 | E02 | | L07 | A05 | E03 | | L04 | A04 | E01 | | L04 | A04 | E02 | | L04 | A04 | E03 | +---------+----------+---------+ 8 rows in set (0.000 sec) MariaDB [libreria]> exit