MariaDB [(none)]> create batabase fechas1; 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 'batabase fechas1' at line 1 MariaDB [(none)]> CREATE DATABASE fechas1; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> use fechas1; Database changed MariaDB [fechas1]> create table pagos -> (identi varchar(4) not null primary key, -> decripcion varchar(50), -> fechaAdquisicion date not null); Query OK, 0 rows affected (0.020 sec) MariaDB [fechas1]> insert into Pagos (identi, descripcion, fechaAdquisicion) values -> ('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'); ERROR 1054 (42S22): Unknown column 'descripcion' in 'field list' MariaDB [fechas1]> drop table pagos -> ; Query OK, 0 rows affected (0.019 sec) MariaDB [fechas1]> create table pagos -> (Identi varchar(4) not null primary key, -> descripcion varchar(50) not null, -> fechaAdquisicion date not null); Query OK, 0 rows affected (0.025 sec) MariaDB [fechas1]> describe pagos; +------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+---------+-------+ | Identi | varchar(4) | NO | PRI | NULL | | | descripcion | varchar(50) | NO | | NULL | | | fechaAdquisicion | date | NO | | NULL | | +------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.038 sec) MariaDB [fechas1]> insert into Pagos (Identi, descripcion, fechaAdquisicion) values ('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'); Query OK, 21 rows affected (0.016 sec) Records: 21 Duplicates: 0 Warnings: 0 MariaDB [fechas1]> 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.001 sec) MariaDB [fechas1]> select * from pagos where fechaAdquisicion < '2012-06-01'; +--------+-------------------+------------------+ | 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.001 sec) MariaDB [fechas1]> select * from pagos order by fechaAdquisicion asc limit 1; +--------+-------------+------------------+ | Identi | descripcion | fechaAdquisicion | +--------+-------------+------------------+ | 0015 | hub | 2012-01-16 | +--------+-------------+------------------+ 1 row in set (0.001 sec) MariaDB [fechas1]> select * from pagos where descripcion like '%o' or descripcion llike '%m'; 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 'llike '%m'' at line 1 MariaDB [fechas1]> 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.001 sec) MariaDB [fechas1]> select * from pagos where right (descripcion, 1) not in ('a', 'e', 'i', 'o', '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.001 sec) MariaDB [fechas1]> select identi, descripcion, fechaAdquisicion, -> case -> when month(fechaAdquisicion) between 1 and 6 then date_add(fechaAdquisicion, interval 5 month) -> when month(fechaAdquisicion) between 7 and 12 then date_add(fechaAdquisicion, interval 8 month) -> end as fechapago -> from pagos; +--------+--------------------+------------------+------------+ | identi | descripcion | fechaAdquisicion | fechapago | +--------+--------------------+------------------+------------+ | 0001 | Chasis | 2012-09-02 | 2013-05-02 | | 0002 | mouse | 2013-07-29 | 2014-03-29 | | 0003 | teclado | 2012-06-04 | 2012-11-04 | | 0004 | ram | 2012-03-27 | 2012-08-27 | | 0005 | Memoria usb | 2012-12-06 | 2013-08-06 | | 0006 | ups | 2012-03-25 | 2012-08-25 | | 0007 | regulador voltaje | 2012-05-08 | 2012-10-08 | | 0008 | cableado | 2012-04-24 | 2012-09-24 | | 0009 | Tablet | 2012-08-10 | 2013-04-10 | | 0010 | Escanner | 2012-03-21 | 2012-08-21 | | 0011 | lapiz optico | 2012-02-12 | 2012-07-12 | | 0012 | Procedador pentium | 2012-06-19 | 2012-11-19 | | 0013 | Procesador SN | 2012-04-14 | 2012-09-14 | | 0014 | Unidad CD | 2012-09-17 | 2013-05-17 | | 0015 | hub | 2012-01-16 | 2012-06-16 | | 0016 | Multifuncional | 2013-04-15 | 2013-09-15 | | 0017 | Camara | 2013-03-18 | 2013-08-18 | | 0018 | Board | 2013-01-13 | 2013-06-13 | | 0019 | impresora laser | 2013-10-20 | 2014-06-20 | | 0020 | Fuente | 2013-07-11 | 2014-03-11 | | 0021 | disco duro | 2013-11-22 | 2014-07-22 | +--------+--------------------+------------------+------------+ 21 rows in set (0.001 sec) MariaDB [fechas1]> exit