MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.129 sec) MariaDB [(none)]> create database libreria; Query OK, 1 row affected (0.047 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | information_schema | | libreria | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 7 rows in set (0.001 sec) MariaDB [(none)]> use libreria; Database changed MariaDB [libreria]> create table Libro -> (idlibro varchar(5) not null primary key, -> titulo varchar(20) not null, -> nropagina int(4) not null, -> precio int(7) not null, -> codigomat varchar(5) not null); Query OK, 0 rows affected (0.405 sec) MariaDB [libreria]> show tables; +--------------------+ | Tables_in_libreria | +--------------------+ | libro | +--------------------+ 1 row in set (0.035 sec) MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | PRI | NULL | | | titulo | varchar(20) | NO | | NULL | | | nropagina | int(4) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | codigomat | varchar(5) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.040 sec) MariaDB [libreria]> create table Materia -> (codigomat varchar(5) not null primary key, -> nombre varchar(20) not null); Query OK, 0 rows affected (0.165 sec) MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.007 sec) MariaDB [libreria]> alter table libro drop codigomat; Query OK, 0 rows affected (0.493 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | PRI | NULL | | | titulo | varchar(20) | NO | | NULL | | | nropagina | int(4) | NO | | NULL | | | precio | int(7) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 4 rows in set (0.059 sec) MariaDB [libreria]> alter table libro add -> codigomat varchar(5) not null, -> foreign key(codigomat) references libro(codigomat) 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(codigomat) references libro(codigomat) on delete cascade on updat...' at line 3 MariaDB [libreria]> alter table libro add -> codigomat varchar(5) 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 '' at line 2 MariaDB [libreria]> alter table libro add -> codigomat varchar(5) not null; Query OK, 0 rows affected (0.249 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | PRI | NULL | | | titulo | varchar(20) | NO | | NULL | | | nropagina | int(4) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | codigomat | varchar(5) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.024 sec) MariaDB [libreria]> foreign key(codigomat) references libro(codigomat) 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(codigomat) references libro(codigomat) on delete cascade on updat...' at line 1 MariaDB [libreria]> ALTER TABLE libro ADD FOREIGN KEY (codigomat) REFERENCES materia(codigomat); Query OK, 0 rows affected (0.986 sec) Records: 0 Duplicates: 0 Warnings: 0 MariaDB [libreria]> describe 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 'table libro' at line 1 MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | PRI | NULL | | | titulo | varchar(20) | NO | | NULL | | | nropagina | int(4) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | codigomat | varchar(5) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.008 sec) MariaDB [libreria]> create table Autor -> (codautor varchar(5) not null primary key, -> nombre varchar(20) not null); Query OK, 0 rows affected (0.196 sec) MariaDB [libreria]> create table Editorial -> (codedit varchar(5) not null primary key, -> nombre varchar(20) not null); Query OK, 0 rows affected (0.177 sec) MariaDB [libreria]> create table liautedi -> (idlibro varchar(5) not null, -> codautor varchar(5) not null, -> codedit 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, -> foreign key(codedit) references Editorial(codedit) on delete cascade on update cascade); Query OK, 0 rows affected (0.237 sec) MariaDB [libreria]> describe luautedi -> ; ERROR 1146 (42S02): Table 'libreria.luautedi' doesn't exist MariaDB [libreria]> describe liautedi; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | MUL | NULL | | | codautor | varchar(5) | NO | MUL | NULL | | | codedit | varchar(5) | NO | MUL | NULL | | +----------+------------+------+-----+---------+-------+ 3 rows in set (0.040 sec) MariaDB [libreria]> insert into Materia(codigomat, nombre) -> values(M01, Calculo), -> values(M02, Matematicas); 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 'values(M02, Matematicas)' at line 3 MariaDB [libreria]> insert into Materia(codigomat, nombre) -> values(M01, Calculo), -> (M02, Matematicas); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> insert into Materia(codigomat, nombre) -> values(M01, Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [libreria]> show 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]> select * from materia; Empty set (0.078 sec) MariaDB [libreria]> insert into Materia(codigomat, nombre) -> values(M01 Calculo); 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 'Calculo)' at line 2 MariaDB [libreria]> insert into Materia(codigomat, nombre) -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> insert into materia(codigomat, nombre) -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> insert into materia(codigomat, nombre) -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.009 sec) MariaDB [libreria]> insert into materia(codigomat nombre) -> values(M01 Calculo); 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 'nombre) values(M01 Calculo)' at line 1 MariaDB [libreria]> insert into materia(M01, Calculo); 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 [libreria]> insert into materia(codigomat,nombre) -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> select * from materia; Empty set (0.000 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values(Calculo); ERROR 1054 (42S22): Unknown column 'Calculo' in 'field list' MariaDB [libreria]> insert into materia(codigomat,nombre) -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> insert into materia -> values(M01,Calculo); ERROR 1054 (42S22): Unknown column 'M01' in 'field list' MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M01','Calculo'); Query OK, 1 row affected (0.063 sec) MariaDB [libreria]> select * from materia; +-----------+---------+ | codigomat | nombre | +-----------+---------+ | M01 | Calculo | +-----------+---------+ 1 row in set (0.000 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values(M02,Matematicas), -> values(M03,Estructura de datos), -> values(M04,Ingles), -> values(M08,Diagramacion), -> values(M06,Contabilidad), -> values(M07,Redes), -> values(M05,Sistemas de inf), -> values(M09,Base de datos); 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 'values(M03,Estructura de datos), values(M04,Ingles), values(M08,Diagramacion)...' at line 3 MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M02','Matematicas'), -> values('M03','Estructura de datos'); 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 'values('M03','Estructura de datos')' at line 3 MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M02','Matematicas'); Query OK, 1 row affected (0.068 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M03','Estructura de datos'); Query OK, 1 row affected (0.025 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M04','Ingles'); Query OK, 1 row affected (0.040 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M05','Sistemas de inf'); Query OK, 1 row affected (0.052 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M08','Diagramacion'); Query OK, 1 row affected (0.026 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M06','Contabilidad'); Query OK, 1 row affected (0.034 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M07','Redes'); Query OK, 1 row affected (0.028 sec) MariaDB [libreria]> insert into materia(codigomat,nombre) -> values('M09','Base de datos'); Query OK, 1 row affected (0.048 sec) MariaDB [libreria]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingles | | M05 | Sistemas de inf | | M06 | Contabilidad | | M07 | Redes | | M08 | Diagramacion | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.000 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L01','Calculo II',120,55000,'M01'); Query OK, 1 row affected (0.047 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L02','BD II',150,65000,'M09'); Query OK, 1 row affected (0.064 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L03','Estructura de datos',180,85000,'M03'); Query OK, 1 row affected (0.070 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L08','Diagramacion',85,45000,'M08'); Query OK, 1 row affected (0.052 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L05','Admon en una pagina',70,7500,'M05'); Query OK, 1 row affected (0.034 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L06','Contabilidad I',170,27500,'M06'); Query OK, 1 row affected (0.074 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L07','Redes',370,32500,'M07'); Query OK, 1 row affected (0.032 sec) MariaDB [libreria]> insert into libro(idlibro,titulo,nropagina,precio,codigomat) -> values('L04','Ingles',280,105000,'M04'); Query OK, 1 row affected (0.032 sec) MariaDB [libreria]> select * from libro; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | 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.001 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A01','Luis Joyanes'); Query OK, 1 row affected (0.196 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A0','Luis Joyanes'); Query OK, 1 row affected (0.170 sec) MariaDB [libreria]> MariaDB [libreria]> delete from autor where codautor = A0 -> ; ERROR 1054 (42S22): Unknown column 'A0' in 'where clause' MariaDB [libreria]> select * from AUTOR; +----------+--------------+ | codautor | nombre | +----------+--------------+ | A0 | Luis Joyanes | | A01 | Luis Joyanes | +----------+--------------+ 2 rows in set (0.000 sec) MariaDB [libreria]> delete from autor -> ; Query OK, 2 rows affected (0.056 sec) MariaDB [libreria]> select * from AUTOR; Empty set (0.001 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A01','Luis Joyanes'); Query OK, 1 row affected (0.026 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A02','Jorge Vasquez Posada'); Query OK, 1 row affected (0.075 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A03','Jhon Soars'); Query OK, 1 row affected (0.030 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A04','Riaz Khadem'); Query OK, 1 row affected (0.062 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A05','Robert Lorber'); Query OK, 1 row affected (0.033 sec) MariaDB [libreria]> insert into autor(codautor,nombre) -> values('A06','Mario Dream'); Query OK, 1 row affected (0.038 sec) MariaDB [libreria]> 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 [libreria]> insert into editorial(codedit,nombre) -> values('E01','Oveja Negra'); Query OK, 1 row affected (0.045 sec) MariaDB [libreria]> insert into editorial(codedit,nombre) -> values('E02','Norma'); Query OK, 1 row affected (0.034 sec) MariaDB [libreria]> insert into editorial(codedit,nombre) -> values('E03','Mc Graw Hill'); Query OK, 1 row affected (0.045 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L02','A01'.'E01'); 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 '.'E01')' at line 2 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]> describe coedit; ERROR 1146 (42S02): Table 'libreria.coedit' doesn't exist MariaDB [libreria]> describe editorial; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | codedit | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.017 sec) MariaDB [libreria]> describe liautedi; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | MUL | NULL | | | codautor | varchar(5) | NO | MUL | NULL | | | codedit | varchar(5) | NO | MUL | NULL | | +----------+------------+------+-----+---------+-------+ 3 rows in set (0.104 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L02','A01','E01'); Query OK, 1 row affected (0.052 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L02','A05','E03'); Query OK, 1 row affected (0.032 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L06','A02','E02'); Query OK, 1 row affected (0.030 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L07','A05','E03'); Query OK, 1 row affected (0.032 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L04','A04','E01'); Query OK, 1 row affected (0.032 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L04','A04','E02'); Query OK, 1 row affected (0.035 sec) MariaDB [libreria]> insert into liautedi(idlibro,codautor,codedit) -> values('L04','A04','E03'); Query OK, 1 row affected (0.088 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 | +---------+----------+---------+ 7 rows in set (0.000 sec) MariaDB [libreria]> show tables; +--------------------+ | Tables_in_libreria | +--------------------+ | autor | | editorial | | liautedi | | libro | | materia | +--------------------+ 5 rows in set (0.001 sec) MariaDB [libreria]> describe libro; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | idlibro | varchar(5) | NO | PRI | NULL | | | titulo | varchar(20) | NO | | NULL | | | nropagina | int(4) | NO | | NULL | | | precio | int(7) | NO | | NULL | | | codigomat | varchar(5) | NO | MUL | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.009 sec) MariaDB [libreria]> select * from libro; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | 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 [libreria]> describe autor; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | codautor | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.012 sec) MariaDB [libreria]> 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 [libreria]> describe editorial; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | codedit | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.013 sec) MariaDB [libreria]> select * from editorial; +---------+--------------+ | codedit | nombre | +---------+--------------+ | E01 | Oveja Negra | | E02 | Norma | | E03 | Mc Graw Hill | +---------+--------------+ 3 rows in set (0.002 sec) MariaDB [libreria]> describe materias; ERROR 1146 (42S02): Table 'libreria.materias' doesn't exist MariaDB [libreria]> describe materia; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [libreria]> select * from materia; +-----------+---------------------+ | codigomat | nombre | +-----------+---------------------+ | M01 | Calculo | | M02 | Matematicas | | M03 | Estructura de datos | | M04 | Ingles | | M05 | Sistemas de inf | | M06 | Contabilidad | | M07 | Redes | | M08 | Diagramacion | | M09 | Base de datos | +-----------+---------------------+ 9 rows in set (0.013 sec) MariaDB [libreria]> select titulo,precio from libro; +---------------------+--------+ | titulo | precio | +---------------------+--------+ | Calculo II | 55000 | | BD II | 65000 | | Estructura de datos | 85000 | | Ingles | 105000 | | Admon en una pagina | 7500 | | Contabilidad I | 27500 | | Redes | 32500 | | Diagramacion | 45000 | +---------------------+--------+ 8 rows in set (0.000 sec) MariaDB [libreria]> alter table materia rename to asignatura; Query OK, 0 rows affected (0.165 sec) MariaDB [libreria]> describe asignatura; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigomat | varchar(5) | NO | PRI | NULL | | | nombre | varchar(20) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 2 rows in set (0.048 sec) MariaDB [libreria]> SELECT * FROM libros WHERE nombre LIKE '%redes%'; ERROR 1146 (42S02): Table 'libreria.libros' doesn't exist MariaDB [libreria]> SELECT * FROM libro WHERE nombre LIKE '%redes%'; ERROR 1054 (42S22): Unknown column 'nombre' in 'where clause' MariaDB [libreria]> SELECT * FROM libro WHERE titulo LIKE '%redes%'; +---------+--------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+--------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+--------+-----------+--------+-----------+ 1 row in set (0.019 sec) MariaDB [libreria]> SELECT * FROM libro WHERE titulo LIKE '%redes%'; +---------+--------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+--------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+--------+-----------+--------+-----------+ 1 row in set (0.001 sec) MariaDB [libreria]> SELECT * FROM libro WHERE titulo LIKE '%r%'; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L03 | Estructura de datos | 180 | 85000 | M03 | | L07 | Redes | 370 | 32500 | M07 | | L08 | Diagramacion | 85 | 45000 | M08 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.000 sec) MariaDB [libreria]> SELECT * FROM libro WHERE titulo LIKE '%s'; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L07 | Redes | 370 | 32500 | M07 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.000 sec) MariaDB [libreria]> SELECT * FROM libro WHERE titulo LIKE 'c%'; +---------+----------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+----------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L06 | Contabilidad I | 170 | 27500 | M06 | +---------+----------------+-----------+--------+-----------+ 2 rows in set (0.060 sec) MariaDB [libreria]> SELECT * FROM libro WHERE idlibro = 'L03' -> || idlibro = 'L04' -> || idlibro = 'L05'; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | | L05 | Admon en una pagina | 70 | 7500 | M05 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.073 sec) MariaDB [libreria]> SELECT * FROM libro WHERE idlibro BETWEEN 'L02' AND 'L06'; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | 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 | +---------+---------------------+-----------+--------+-----------+ 5 rows in set (0.037 sec) MariaDB [libreria]> SELECT * FROM libro WHERE nropagina >= 100 AND precio >= 65000; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L02 | BD II | 150 | 65000 | M09 | | L03 | Estructura de datos | 180 | 85000 | M03 | | L04 | Ingles | 280 | 105000 | M04 | +---------+---------------------+-----------+--------+-----------+ 3 rows in set (0.013 sec) MariaDB [libreria]> SELECT * FROM libro WHERE titulo = 'Redes'; +---------+--------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+--------+-----------+--------+-----------+ | L07 | Redes | 370 | 32500 | M07 | +---------+--------+-----------+--------+-----------+ 1 row in set (0.000 sec) MariaDB [libreria]> SELECT titulo,nropagina,precio FROM libro WHERE precio >= 50000; +---------------------+-----------+--------+ | titulo | nropagina | precio | +---------------------+-----------+--------+ | Calculo II | 120 | 55000 | | BD II | 150 | 65000 | | Estructura de datos | 180 | 85000 | | Ingles | 280 | 105000 | +---------------------+-----------+--------+ 4 rows in set (0.000 sec) MariaDB [libreria]> SELECT * FROM libro WHERE nropagina < 160; +---------+---------------------+-----------+--------+-----------+ | idlibro | titulo | nropagina | precio | codigomat | +---------+---------------------+-----------+--------+-----------+ | L01 | Calculo II | 120 | 55000 | M01 | | L02 | BD II | 150 | 65000 | M09 | | L05 | Admon en una pagina | 70 | 7500 | M05 | | L08 | Diagramacion | 85 | 45000 | M08 | +---------+---------------------+-----------+--------+-----------+ 4 rows in set (0.015 sec) MariaDB [libreria]> exit