MariaDB [fechas]> show databases; +--------------------+ | Database | +--------------------+ | biblioteca | | consulta_externa | | empleados | | facturacion | | fechas | | information_schema | | libreria | | matricula | | matricula2 | | mysql | | performance_schema | | phpmyadmin | | proyectofinal | | taller02 | | taller2 | | test | | urgencias | +--------------------+ 17 rows in set (0.04 sec) MariaDB [fechas]> show tables; +------------------+ | Tables_in_fechas | +------------------+ | pagos | +------------------+ 1 row in set (0.00 sec) MariaDB [fechas]> select * from pagos; +--------+--------------------+------------------+ | identi | descripcion | fechaadquisicion | +--------+--------------------+------------------+ | 0001 | Chasis | 2012-09-02 | | 0002 | mouse | 2013-07-29 | | 0003 | teclado | 2012-06-04 | | 0004 | ram | 2012-03-27 | | 0005 | Memoria usb | 2012-12-06 | | 0006 | ups | 2012-03-25 | | 0007 | regulador voltaje | 2012-05-08 | | 0008 | cableado | 2012-04-24 | | 0009 | Tablet | 2012-08-10 | | 0010 | Escanner | 2012-03-21 | | 0011 | lapiz optico | 2012-02-12 | | 0012 | Procedador pentium | 2012-06-19 | | 0013 | Procesador SN | 2012-04-14 | | 0014 | Unidad CD | 2012-09-17 | | 0015 | hub | 2012-01-16 | | 0016 | Multifuncional | 2013-04-15 | | 0017 | Camara | 2013-03-18 | | 0018 | Board | 2013-01-13 | | 0019 | impresora laser | 2013-10-20 | | 0020 | Fuente | 2013-07-11 | | 0021 | disco duro | 2013-11-22 | +--------+--------------------+------------------+ 21 rows in set (0.00 sec) MariaDB [fechas]> describe pagos; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | identi | varchar(6) | NO | | NULL | | | descripcion | varchar(50) | NO | | NULL | | | fechaadquisicion | date | YES | | NULL | | +------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.05 sec) MariaDB [fechas]> select * from Pagos where year(fechaadquisicion) = 2012 and month(fechaadquisicion) < 6; +--------+-------------------+------------------+ | identi | descripcion | fechaadquisicion | +--------+-------------------+------------------+ | 0004 | ram | 2012-03-27 | | 0006 | ups | 2012-03-25 | | 0007 | regulador voltaje | 2012-05-08 | | 0008 | cableado | 2012-04-24 | | 0010 | Escanner | 2012-03-21 | | 0011 | lapiz optico | 2012-02-12 | | 0013 | Procesador SN | 2012-04-14 | | 0015 | hub | 2012-01-16 | +--------+-------------------+------------------+ 8 rows in set (0.04 sec) MariaDB [fechas]> select * from pagos where fechaadquisicion = (select max(fechaadquisicion) from pagos); +--------+-------------+------------------+ | identi | descripcion | fechaadquisicion | +--------+-------------+------------------+ | 0021 | disco duro | 2013-11-22 | +--------+-------------+------------------+ 1 row in set (0.03 sec) MariaDB [fechas]> select * from pagos where descripcion like '%o' or descripcion like '%m'; +--------+--------------------+------------------+ | identi | descripcion | fechaadquisicion | +--------+--------------------+------------------+ | 0003 | teclado | 2012-06-04 | | 0004 | ram | 2012-03-27 | | 0008 | cableado | 2012-04-24 | | 0011 | lapiz optico | 2012-02-12 | | 0012 | Procedador pentium | 2012-06-19 | | 0021 | disco duro | 2013-11-22 | +--------+--------------------+------------------+ 6 rows in set (0.00 sec) MariaDB [fechas]> select * from pagos where descripcion not like '%a' and descripcion not like '%e' and descripcion not like '%i' and descripcion not like '%o' and descripcion not like '%u'; +--------+--------------------+------------------+ | identi | descripcion | fechaadquisicion | +--------+--------------------+------------------+ | 0001 | Chasis | 2012-09-02 | | 0004 | ram | 2012-03-27 | | 0005 | Memoria usb | 2012-12-06 | | 0006 | ups | 2012-03-25 | | 0009 | Tablet | 2012-08-10 | | 0010 | Escanner | 2012-03-21 | | 0012 | Procedador pentium | 2012-06-19 | | 0013 | Procesador SN | 2012-04-14 | | 0014 | Unidad CD | 2012-09-17 | | 0015 | hub | 2012-01-16 | | 0016 | Multifuncional | 2013-04-15 | | 0018 | Board | 2013-01-13 | | 0019 | impresora laser | 2013-10-20 | +--------+--------------------+------------------+ 13 rows in set (0.00 sec) MariaDB [fechas]> select Identi, descripcion, fechaadquisicion, if(month(fechaadquisicion) <= 6, 'Dar 5 meses plazo', 'No dar plazo') As 'Plazo' from pagos; +--------+--------------------+------------------+-------------------+ | Identi | descripcion | fechaadquisicion | Plazo | +--------+--------------------+------------------+-------------------+ | 0001 | Chasis | 2012-09-02 | No dar plazo | | 0002 | mouse | 2013-07-29 | No dar plazo | | 0003 | teclado | 2012-06-04 | Dar 5 meses plazo | | 0004 | ram | 2012-03-27 | Dar 5 meses plazo | | 0005 | Memoria usb | 2012-12-06 | No dar plazo | | 0006 | ups | 2012-03-25 | Dar 5 meses plazo | | 0007 | regulador voltaje | 2012-05-08 | Dar 5 meses plazo | | 0008 | cableado | 2012-04-24 | Dar 5 meses plazo | | 0009 | Tablet | 2012-08-10 | No dar plazo | | 0010 | Escanner | 2012-03-21 | Dar 5 meses plazo | | 0011 | lapiz optico | 2012-02-12 | Dar 5 meses plazo | | 0012 | Procedador pentium | 2012-06-19 | Dar 5 meses plazo | | 0013 | Procesador SN | 2012-04-14 | Dar 5 meses plazo | | 0014 | Unidad CD | 2012-09-17 | No dar plazo | | 0015 | hub | 2012-01-16 | Dar 5 meses plazo | | 0016 | Multifuncional | 2013-04-15 | Dar 5 meses plazo | | 0017 | Camara | 2013-03-18 | Dar 5 meses plazo | | 0018 | Board | 2013-01-13 | Dar 5 meses plazo | | 0019 | impresora laser | 2013-10-20 | No dar plazo | | 0020 | Fuente | 2013-07-11 | No dar plazo | | 0021 | disco duro | 2013-11-22 | No dar plazo | +--------+--------------------+------------------+-------------------+ 21 rows in set (0.03 sec) MariaDB [fechas]> select Identi, descripcion, fechaadquisicion, if(month(fechaadquisicion) > 6, 'Dar 8 meses plazo', 'No dar plazo') As 'Plazo' from pagos; +--------+--------------------+------------------+-------------------+ | Identi | descripcion | fechaadquisicion | Plazo | +--------+--------------------+------------------+-------------------+ | 0001 | Chasis | 2012-09-02 | Dar 8 meses plazo | | 0002 | mouse | 2013-07-29 | Dar 8 meses plazo | | 0003 | teclado | 2012-06-04 | No dar plazo | | 0004 | ram | 2012-03-27 | No dar plazo | | 0005 | Memoria usb | 2012-12-06 | Dar 8 meses plazo | | 0006 | ups | 2012-03-25 | No dar plazo | | 0007 | regulador voltaje | 2012-05-08 | No dar plazo | | 0008 | cableado | 2012-04-24 | No dar plazo | | 0009 | Tablet | 2012-08-10 | Dar 8 meses plazo | | 0010 | Escanner | 2012-03-21 | No dar plazo | | 0011 | lapiz optico | 2012-02-12 | No dar plazo | | 0012 | Procedador pentium | 2012-06-19 | No dar plazo | | 0013 | Procesador SN | 2012-04-14 | No dar plazo | | 0014 | Unidad CD | 2012-09-17 | Dar 8 meses plazo | | 0015 | hub | 2012-01-16 | No dar plazo | | 0016 | Multifuncional | 2013-04-15 | No dar plazo | | 0017 | Camara | 2013-03-18 | No dar plazo | | 0018 | Board | 2013-01-13 | No dar plazo | | 0019 | impresora laser | 2013-10-20 | Dar 8 meses plazo | | 0020 | Fuente | 2013-07-11 | Dar 8 meses plazo | | 0021 | disco duro | 2013-11-22 | Dar 8 meses plazo | +--------+--------------------+------------------+-------------------+ 21 rows in set (0.00 sec) MariaDB [fechas]> exit