mysql> create database parcial;
Query OK, 1 row affected (0.00 sec)

mysql> use database;
ERROR 1049 (42000): Unknown database 'database'
mysql> use parcial;
Database changed
mysql> create table exaparcial
    -> (codigo char(2) not null primary key,
    -> nombre char(100) not null,
    -> precio int not null,
    -> cantidad int not null)engine=innodb;
Query OK, 0 rows affected (0.11 sec)

mysql> describe exaparcial;
+----------+-----------+------+-----+---------+-------+
| Field    | Type      | Null | Key | Default | Extra |
+----------+-----------+------+-----+---------+-------+
| codigo   | char(2)   | NO   | PRI | NULL    |       |
| nombre   | char(100) | NO   |     | NULL    |       |
| precio   | int(11)   | NO   |     | NULL    |       |
| cantidad | int(11)   | NO   |     | NULL    |       |
+----------+-----------+------+-----+---------+-------+
4 rows in set (0.04 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("01","Lo que el viento se llevo",50000,10);
Query OK, 1 row affected (0.04 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("02","Comunicaciones y redes",100000,50);
Query OK, 1 row affected (0.05 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("03","Sitemas Operativos",80000,25);
Query OK, 1 row affected (0.02 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("04","Teoria General de Sistemas",80000,20);
Query OK, 1 row affected (0.04 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("05","Programacion de Computadores",70000,30);
Query OK, 1 row affected (0.02 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("06","Estructura de Datos",100000,5);
Query OK, 1 row affected (0.01 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("07","Programacion en Java",100000,6);
Query OK, 1 row affected (0.03 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("08","Derecho informatico",120000,7);
Query OK, 1 row affected (0.03 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("09","Base de Datos",120000,10);
Query OK, 1 row affected (0.03 sec)

mysql> insert into exaparcial(codigo,nombre,precio,cantidad) values("10","Programacion en Mysql",120000,15);
Query OK, 1 row affected (0.03 sec)

mysql> select * from exaparcial;
+--------+------------------------------+--------+----------+
| codigo | nombre                       | precio | cantidad |
+--------+------------------------------+--------+----------+
| 01     | Lo que el viento se llevo    |  50000 |       10 |
| 02     | Comunicaciones y redes       | 100000 |       50 |
| 03     | Sitemas Operativos           |  80000 |       25 |
| 04     | Teoria General de Sistemas   |  80000 |       20 |
| 05     | Programacion de Computadores |  70000 |       30 |
| 06     | Estructura de Datos          | 100000 |        5 |
| 07     | Programacion en Java         | 100000 |        6 |
| 08     | Derecho informatico          | 120000 |        7 |
| 09     | Base de Datos                | 120000 |       10 |
| 10     | Programacion en Mysql        | 120000 |       15 |
+--------+------------------------------+--------+----------+
10 rows in set (0.00 sec)

mysql> alter table exaparcial rename to libro;
Query OK, 0 rows affected (0.03 sec)

mysql> show tables;
+-------------------+
| Tables_in_parcial |
+-------------------+
| libro             |
+-------------------+
1 row in set (0.00 sec)

mysql> alter table libro change nombre descripcion char(100) not null;
Query OK, 10 rows affected (0.26 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql> select * from libro;
+--------+------------------------------+--------+----------+
| codigo | descripcion                  | precio | cantidad |
+--------+------------------------------+--------+----------+
| 01     | Lo que el viento se llevo    |  50000 |       10 |
| 02     | Comunicaciones y redes       | 100000 |       50 |
| 03     | Sitemas Operativos           |  80000 |       25 |
| 04     | Teoria General de Sistemas   |  80000 |       20 |
| 05     | Programacion de Computadores |  70000 |       30 |
| 06     | Estructura de Datos          | 100000 |        5 |
| 07     | Programacion en Java         | 100000 |        6 |
| 08     | Derecho informatico          | 120000 |        7 |
| 09     | Base de Datos                | 120000 |       10 |
| 10     | Programacion en Mysql        | 120000 |       15 |
+--------+------------------------------+--------+----------+
10 rows in set (0.00 sec)

mysql> alter table libro add vtotal int null;
Query OK, 10 rows affected (0.16 sec)
Records: 10  Duplicates: 0  Warnings: 0

mysql> describe libro;
+-------------+-----------+------+-----+---------+-------+
| Field       | Type      | Null | Key | Default | Extra |
+-------------+-----------+------+-----+---------+-------+
| codigo      | char(2)   | NO   | PRI | NULL    |       |
| descripcion | char(100) | NO   |     | NULL    |       |
| precio      | int(11)   | NO   |     | NULL    |       |
| cantidad    | int(11)   | NO   |     | NULL    |       |
| vtotal      | int(11)   | YES  |     | NULL    |       |
+-------------+-----------+------+-----+---------+-------+
5 rows in set (0.02 sec)

mysql> update libro set vtotal=precio*cantidad;
Query OK, 10 rows affected (0.07 sec)
Rows matched: 10  Changed: 10  Warnings: 0

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  50000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  80000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  80000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  70000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> select * from into outfile "d:/consultaslibro.xls";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into outfile "d:/consultaslibro.xls"' at line 1
mysql> select * from into outfile "d:/consultaslibro.xls;
    "> ;
    "> select * from into outfile 'd:/consultaslibro.xls';
    "> ;
    "> "
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into outfile "d:/consultaslibro.xls;
;
select * from into outfile 'd:/consultasl' at line 1
mysql> select * from libro into outfile 'd:/consultaslibro.xls';
Query OK, 10 rows affected (0.02 sec)

mysql> select max(vtotal) as "El Valor total mayor es: " from libro;
+---------------------------+
| El Valor total mayor es:  |
+---------------------------+
|                   5000000 |
+---------------------------+
1 row in set (0.01 sec)

mysql> select * from libro into outfile 'd:/consultaslibro.xls';
ERROR 1086 (HY000): File 'd:/consultaslibro.xls' already exists
mysql> select * from libro into outfile 'd:/consultaslibro2.xls';
Query OK, 10 rows affected (0.00 sec)

mysql> select max(vtotal) as "El Valor total mayor es: " from libro into outfile 'd:/consultaslibro2.xls';
Query OK, 1 row affected (0.00 sec)

mysql> select avg(vtotal as "El promedio total de los libros de programacion es de: " from estudiantes where descripcion="%Programacion%";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as "El promedio total de los libros de programacion es de: " from estudiantes wh' at line 1
mysql> select avg(vtotal as "El promedio total de los libros de programacion es de: " from libro where descripcion="%Programacion%";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as "El promedio total de los libros de programacion es de: " from libro where de' at line 1
mysql> select avg(vtotal) as "El promedio total de los libros de programacion es de: " from libro where descripcion="%Programacion%";
+---------------------------------------------------------+
| El promedio total de los libros de programacion es de:  |
+---------------------------------------------------------+
|                                                    NULL |
+---------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select avg(vtotal) as "El promedio total de los libros de programacion es de: " from libro where descripcion like"%Programacion%";
+---------------------------------------------------------+
| El promedio total de los libros de programacion es de:  |
+---------------------------------------------------------+
|                                            1500000.0000 |
+---------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select avg(vtotal) as "El promedio total de los libros de programacion es de: " from libro where descripcion like"%Programacion%" into outfile 'd:/consultaslibro3.xls';
Query OK, 1 row affected (0.01 sec)

mysql> select sum(vtotal) as "La Suma de los libros con cantidad inferior a 30 son: " from libro where cantidad<30;
+--------------------------------------------------------+
| La Suma de los libros con cantidad inferior a 30 son:  |
+--------------------------------------------------------+
|                                                9040000 |
+--------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select sum(vtotal) as "La Suma de los totales de los libros con cantidad inferior a 30 son: " from libro where cantidad<30 into outfile 'd:/consultaslibro4.xls';
Query OK, 1 row affected (0.00 sec)

mysql> update libro set vtotal=90000 where vtotal<=80000;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  50000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  80000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  80000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  70000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> update libro set vtotal=precio*cantidad;
Query OK, 0 rows affected (0.03 sec)
Rows matched: 10  Changed: 0  Warnings: 0

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  50000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  80000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  80000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  70000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> update libro set precio=90000 where precio<=80000;
Query OK, 4 rows affected (0.03 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  90000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  90000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  90000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> update libro set precio=90000 where precio<=80000 into out file 'd:/consultaslibro.xls';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into out file 'd:/consultaslibro.xls'' at line 1
mysql> update libro set precio=90000 where precio<=80000 into out file 'd:/consultaslibro5.xls';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'into out file 'd:/consultaslibro5.xls'' at line 1
mysql> select * from libro into outfile 'd:/consultaslibro5.xls';
Query OK, 10 rows affected (0.01 sec)

mysql> select * from libro where precio between 90000 and 100000 and cantidad>30 and descripcion like"%o%";
+--------+------------------------+--------+----------+---------+
| codigo | descripcion            | precio | cantidad | vtotal  |
+--------+------------------------+--------+----------+---------+
| 02     | Comunicaciones y redes | 100000 |       50 | 5000000 |
+--------+------------------------+--------+----------+---------+
1 row in set (0.00 sec)

mysql> select * from libro where precio between 90000 and 100000 and cantidad>30 and descripcion like"%o%" into out file 'd:consultaslibro6.xls';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out file 'd:consultaslibro6.xls'' at line 1
mysql> select * from libro where precio between 90000 and 100000 and cantidad>30 and descripcion like"%o%" into outfile 'd:consultaslibro6.xls';
Query OK, 1 row affected (0.00 sec)

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  90000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  90000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  90000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> select * from libro where descripcion like%Programacion% and cantidad<30;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%Programacion% and cantidad<30' at line 1
mysql> select * from libro where descripcion like"%Programacion%" and cantidad<30;
+--------+-----------------------+--------+----------+---------+
| codigo | descripcion           | precio | cantidad | vtotal  |
+--------+-----------------------+--------+----------+---------+
| 07     | Programacion en Java  | 100000 |        6 |  600000 |
| 10     | Programacion en Mysql | 120000 |       15 | 1800000 |
+--------+-----------------------+--------+----------+---------+
2 rows in set (0.00 sec)

mysql> select * from libro where descripcion like"%Programacion%" and cantidad<30 into outfile 'd:/consultaslibro7.xls';
Query OK, 2 rows affected (0.01 sec)

mysql> select * from libro where codigo="01 and codigo="05" and codigo="10";
    "> "
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '05" and codigo="10";
"' at line 1
mysql> select * from libro where codigo="01" and codigo="05" and codigo="10";
Empty set (0.00 sec)

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  90000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  90000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  90000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 06     | Estructura de Datos          | 100000 |        5 |  500000 |
| 07     | Programacion en Java         | 100000 |        6 |  600000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
10 rows in set (0.00 sec)

mysql> select * from libro where codigo="01" or codigo="05" or codigo="10";
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  90000 |       10 |  500000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
3 rows in set (0.02 sec)

mysql> select * from libro where codigo="01" or codigo="05" or codigo="10" into outfile 'd:/consultaslibro8.xls';
Query OK, 3 rows affected (0.00 sec)

mysql> delete from libro where cantidad<=6;
Query OK, 2 rows affected (0.04 sec)

mysql> select * from libro;
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 01     | Lo que el viento se llevo    |  90000 |       10 |  500000 |
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  90000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  90000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 08     | Derecho informatico          | 120000 |        7 |  840000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
| 10     | Programacion en Mysql        | 120000 |       15 | 1800000 |
+--------+------------------------------+--------+----------+---------+
8 rows in set (0.00 sec)

mysql> select * from libro into outfile 'd:/consultaslibro9.slx';
Query OK, 8 rows affected (0.00 sec)

mysql> select * from libro into outfile 'd:/consultaslibro9.xls';
Query OK, 8 rows affected (0.00 sec)

mysql> select * from libro where vtotal between 80000 and 120000;
Empty set (0.00 sec)

mysql> select * from libro where vtotal between 80000 and 120000 into outfile 'd:/consultaslibro10.xls';
Query OK, 0 rows affected (0.01 sec)

mysql> select count(precio) as "El total de articulos que tienen un valor unitario superior a 100000 es: " from libro where precio>100000;
+---------------------------------------------------------------------------+
| El total de articulos que tienen un valor unitario superior a 100000 es:  |
+---------------------------------------------------------------------------+
|                                                                         3 |
+---------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select count(precio) as "El total de articulos que tienen un valor unitario superior a 100000 es: " from libro where precio>100000 into outfile 'd:/consultaslibro11';
Query OK, 1 row affected (0.00 sec)

mysql> select count(precio) as "El total de articulos que tienen un valor unitario superior a 100000 es: " from libro where precio>100000 into outfile 'd:/consultaslibro11.xls';
Query OK, 1 row affected (0.00 sec)

mysql> select * from libro where descripcion like"%s";
+--------+------------------------------+--------+----------+---------+
| codigo | descripcion                  | precio | cantidad | vtotal  |
+--------+------------------------------+--------+----------+---------+
| 02     | Comunicaciones y redes       | 100000 |       50 | 5000000 |
| 03     | Sitemas Operativos           |  90000 |       25 | 2000000 |
| 04     | Teoria General de Sistemas   |  90000 |       20 | 1600000 |
| 05     | Programacion de Computadores |  90000 |       30 | 2100000 |
| 09     | Base de Datos                | 120000 |       10 | 1200000 |
+--------+------------------------------+--------+----------+---------+
5 rows in set (0.00 sec)

mysql> select * from libro where descripcion like"%s" into outfile 'd:/consultaslibro12.xls';
Query OK, 5 rows affected (0.00 sec)

mysql> exit