MariaDB [(none)]> create database ffechas; Query OK, 1 row affected (0.002 sec) MariaDB [(none)]> use ffechas; Database changed MariaDB [ffechas]> create table pagos(Id varchar(4) primary key not null, -> -> Descripcion varchar(60) not null, -> -> Fechasadquisicion datetime); 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 '-> Descripcion varchar(60) not null, -> Fechasadquisicion datetime)' at line 2 MariaDB [ffechas]> create table pagos(Id varchar(4) primary key not null, -> Descripcion varchar(60) not null, -> Fechasadquisicion datetime); Query OK, 0 rows affected (0.011 sec) MariaDB [ffechas]> describe pagos; +-------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+-------------+------+-----+---------+-------+ | Id | varchar(4) | NO | PRI | NULL | | | Descripcion | varchar(60) | NO | | NULL | | | Fechasadquisicion | datetime | YES | | NULL | | +-------------------+-------------+------+-----+---------+-------+ 3 rows in set (0.012 sec) MariaDB [ffechas]> insert into pagos(Id, Descripcion, Fechasadquisicion)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','Procesador 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-10-13'), -> ('0019','Impresora laser','2013-10-20'), -> ('0020','Fuente','2013-07-11'), -> ('0021','Disco duro','2013-11-22'); Query OK, 21 rows affected (0.003 sec) Records: 21 Duplicates: 0 Warnings: 0 MariaDB [ffechas]> select * from pagos; +------+--------------------+---------------------+ | Id | Descripcion | Fechasadquisicion | +------+--------------------+---------------------+ | 0001 | Chasis | 2012-09-02 00:00:00 | | 0002 | Mouse | 2013-07-29 00:00:00 | | 0003 | Teclado | 2012-06-04 00:00:00 | | 0004 | Ram | 2012-03-27 00:00:00 | | 0005 | Memoria usb | 2012-12-06 00:00:00 | | 0006 | UPS | 2012-03-25 00:00:00 | | 0007 | Regulador Voltaje | 2012-05-08 00:00:00 | | 0008 | Cableado | 2012-04-24 00:00:00 | | 0009 | Tablet | 2012-08-10 00:00:00 | | 0010 | Escanner | 2012-03-21 00:00:00 | | 0011 | Lapiz optico | 2012-02-12 00:00:00 | | 0012 | Procesador pentium | 2012-06-19 00:00:00 | | 0013 | Procesador SN | 2012-04-14 00:00:00 | | 0014 | Unidad CD | 2012-09-17 00:00:00 | | 0015 | Hub | 2012-01-16 00:00:00 | | 0016 | Multifuncional | 2013-04-15 00:00:00 | | 0017 | Camara | 2013-03-18 00:00:00 | | 0018 | Board | 2013-10-13 00:00:00 | | 0019 | Impresora laser | 2013-10-20 00:00:00 | | 0020 | Fuente | 2013-07-11 00:00:00 | | 0021 | Disco duro | 2013-11-22 00:00:00 | +------+--------------------+---------------------+ 21 rows in set (0.001 sec) MariaDB [ffechas]> select * from pagos where substr(Fechasadquisicion,1,7) < ('2012-06') ; +------+-------------------+---------------------+ | Id | Descripcion | Fechasadquisicion | +------+-------------------+---------------------+ | 0004 | Ram | 2012-03-27 00:00:00 | | 0006 | UPS | 2012-03-25 00:00:00 | | 0007 | Regulador Voltaje | 2012-05-08 00:00:00 | | 0008 | Cableado | 2012-04-24 00:00:00 | | 0010 | Escanner | 2012-03-21 00:00:00 | | 0011 | Lapiz optico | 2012-02-12 00:00:00 | | 0013 | Procesador SN | 2012-04-14 00:00:00 | | 0015 | Hub | 2012-01-16 00:00:00 | +------+-------------------+---------------------+ 8 rows in set (0.001 sec) MariaDB [ffechas]> select * from pagos where Fechasadquisicion = (select max(Fechasadquisicion) from pagos); +------+-------------+---------------------+ | Id | Descripcion | Fechasadquisicion | +------+-------------+---------------------+ | 0021 | Disco duro | 2013-11-22 00:00:00 | +------+-------------+---------------------+ 1 row in set (0.001 sec) MariaDB [ffechas]> select * from pagos where Descripcion like '%o' or Descripcion like '%m'; +------+--------------------+---------------------+ | Id | Descripcion | Fechasadquisicion | +------+--------------------+---------------------+ | 0003 | Teclado | 2012-06-04 00:00:00 | | 0004 | Ram | 2012-03-27 00:00:00 | | 0008 | Cableado | 2012-04-24 00:00:00 | | 0011 | Lapiz optico | 2012-02-12 00:00:00 | | 0012 | Procesador pentium | 2012-06-19 00:00:00 | | 0021 | Disco duro | 2013-11-22 00:00:00 | +------+--------------------+---------------------+ 6 rows in set (0.000 sec) MariaDB [ffechas]> select * from pagos where Descripcion not rlike '[aeiou]'; Empty set (0.000 sec) MariaDB [ffechas]> select * from pagos where Descripcion not rlike 'aeiou'; +------+--------------------+---------------------+ | Id | Descripcion | Fechasadquisicion | +------+--------------------+---------------------+ | 0001 | Chasis | 2012-09-02 00:00:00 | | 0002 | Mouse | 2013-07-29 00:00:00 | | 0003 | Teclado | 2012-06-04 00:00:00 | | 0004 | Ram | 2012-03-27 00:00:00 | | 0005 | Memoria usb | 2012-12-06 00:00:00 | | 0006 | UPS | 2012-03-25 00:00:00 | | 0007 | Regulador Voltaje | 2012-05-08 00:00:00 | | 0008 | Cableado | 2012-04-24 00:00:00 | | 0009 | Tablet | 2012-08-10 00:00:00 | | 0010 | Escanner | 2012-03-21 00:00:00 | | 0011 | Lapiz optico | 2012-02-12 00:00:00 | | 0012 | Procesador pentium | 2012-06-19 00:00:00 | | 0013 | Procesador SN | 2012-04-14 00:00:00 | | 0014 | Unidad CD | 2012-09-17 00:00:00 | | 0015 | Hub | 2012-01-16 00:00:00 | | 0016 | Multifuncional | 2013-04-15 00:00:00 | | 0017 | Camara | 2013-03-18 00:00:00 | | 0018 | Board | 2013-10-13 00:00:00 | | 0019 | Impresora laser | 2013-10-20 00:00:00 | | 0020 | Fuente | 2013-07-11 00:00:00 | | 0021 | Disco duro | 2013-11-22 00:00:00 | +------+--------------------+---------------------+ 21 rows in set (0.000 sec) MariaDB [ffechas]> select Descripcion,Fechasadquisicion, if(month(Fechasadquisicion) <= 6, 'Plazo 5 Meses', 'Plazo 8 meses')'Plazo Pago' from pagos; +--------------------+---------------------+---------------+ | Descripcion | Fechasadquisicion | Plazo Pago | +--------------------+---------------------+---------------+ | Chasis | 2012-09-02 00:00:00 | Plazo 8 meses | | Mouse | 2013-07-29 00:00:00 | Plazo 8 meses | | Teclado | 2012-06-04 00:00:00 | Plazo 5 Meses | | Ram | 2012-03-27 00:00:00 | Plazo 5 Meses | | Memoria usb | 2012-12-06 00:00:00 | Plazo 8 meses | | UPS | 2012-03-25 00:00:00 | Plazo 5 Meses | | Regulador Voltaje | 2012-05-08 00:00:00 | Plazo 5 Meses | | Cableado | 2012-04-24 00:00:00 | Plazo 5 Meses | | Tablet | 2012-08-10 00:00:00 | Plazo 8 meses | | Escanner | 2012-03-21 00:00:00 | Plazo 5 Meses | | Lapiz optico | 2012-02-12 00:00:00 | Plazo 5 Meses | | Procesador pentium | 2012-06-19 00:00:00 | Plazo 5 Meses | | Procesador SN | 2012-04-14 00:00:00 | Plazo 5 Meses | | Unidad CD | 2012-09-17 00:00:00 | Plazo 8 meses | | Hub | 2012-01-16 00:00:00 | Plazo 5 Meses | | Multifuncional | 2013-04-15 00:00:00 | Plazo 5 Meses | | Camara | 2013-03-18 00:00:00 | Plazo 5 Meses | | Board | 2013-10-13 00:00:00 | Plazo 8 meses | | Impresora laser | 2013-10-20 00:00:00 | Plazo 8 meses | | Fuente | 2013-07-11 00:00:00 | Plazo 8 meses | | Disco duro | 2013-11-22 00:00:00 | Plazo 8 meses | +--------------------+---------------------+---------------+ 21 rows in set (0.001 sec) MariaDB [ffechas]> exit